public final class CellReferenceHelper
extends java.lang.Object
Modifier and Type | Method and Description |
---|---|
static java.lang.String |
getCellReference(Cell c)
Gets the cell reference for the cell
|
static void |
getCellReference(Cell c,
java.lang.StringBuffer sb)
Gets the cell reference for the cell
|
static void |
getCellReference(int column,
boolean colabs,
int row,
boolean rowabs,
java.lang.StringBuffer buf)
Overloaded method which prepends $ for absolute reference
|
static java.lang.String |
getCellReference(int column,
int row)
Gets the cell reference for the specified column and row
|
static void |
getCellReference(int sheet,
int column,
boolean colabs,
int row,
boolean rowabs,
Workbook workbook,
java.lang.StringBuffer buf)
Gets the fully qualified cell reference given the column, row
external sheet reference etc
|
static java.lang.String |
getCellReference(int sheet,
int column,
int row,
Workbook workbook)
Gets the fully qualified cell reference given the column, row
external sheet reference etc
|
static void |
getCellReference(int sheet,
int column,
int row,
Workbook workbook,
java.lang.StringBuffer buf)
Gets the fully qualified cell reference given the column, row
external sheet reference etc
|
static java.lang.String |
getCellReference(int sheet,
int column,
int row,
WritableWorkbook workbook)
Gets the fully qualified cell reference given the column, row
external sheet reference etc
|
static void |
getCellReference(int sheet,
int column,
int row,
WritableWorkbook workbook,
java.lang.StringBuffer buf)
Gets the fully qualified cell reference given the column, row
external sheet reference etc
|
static void |
getCellReference(int column,
int row,
java.lang.StringBuffer buf)
Appends the cell reference for the column and row passed in to the string
buffer
|
static int |
getColumn(java.lang.String s)
Gets the columnn number of the string cell reference
|
static java.lang.String |
getColumnReference(int c)
Gets the column letter corresponding to the 0-based column number
|
static int |
getRow(java.lang.String s)
Gets the row number of the cell reference
|
static java.lang.String |
getSheet(java.lang.String ref)
Gets the sheet name from the cell reference string
|
static boolean |
isColumnRelative(java.lang.String s)
Sees if the column component is relative or not
|
static boolean |
isRowRelative(java.lang.String s)
Sees if the row component is relative or not
|
public static void getCellReference(int column, int row, java.lang.StringBuffer buf)
column
- the columnrow
- the rowbuf
- the string buffer to appendpublic static void getCellReference(int column, boolean colabs, int row, boolean rowabs, java.lang.StringBuffer buf)
column
- the column numbercolabs
- TRUE if the column reference is absoluterow
- the row numberrowabs
- TRUE if the row reference is absolutebuf
- the string bufferpublic static java.lang.String getCellReference(int column, int row)
column
- the columnrow
- the rowpublic static int getColumn(java.lang.String s)
s
- the string to parsepublic static java.lang.String getColumnReference(int c)
c
- the column numberpublic static int getRow(java.lang.String s)
s
- the cell referencepublic static boolean isColumnRelative(java.lang.String s)
s
- the cellpublic static boolean isRowRelative(java.lang.String s)
s
- the cellpublic static void getCellReference(int sheet, int column, int row, Workbook workbook, java.lang.StringBuffer buf)
sheet
- the sheet indexcolumn
- the column indexrow
- the row indexworkbook
- the workbookbuf
- a string bufferpublic static void getCellReference(int sheet, int column, int row, WritableWorkbook workbook, java.lang.StringBuffer buf)
sheet
- the sheetcolumn
- the columnrow
- the rowworkbook
- the workbookbuf
- the bufferpublic static void getCellReference(int sheet, int column, boolean colabs, int row, boolean rowabs, Workbook workbook, java.lang.StringBuffer buf)
sheet
- the sheetcolumn
- the columncolabs
- TRUE if the column is an absolute referencerow
- the rowrowabs
- TRUE if the row is an absolute referenceworkbook
- the workbookbuf
- the string bufferpublic static java.lang.String getCellReference(int sheet, int column, int row, Workbook workbook)
sheet
- the sheetcolumn
- the columnrow
- the rowworkbook
- the workbookpublic static java.lang.String getCellReference(int sheet, int column, int row, WritableWorkbook workbook)
sheet
- the sheetcolumn
- the columnrow
- the rowworkbook
- the workbookpublic static java.lang.String getSheet(java.lang.String ref)
ref
- the cell referencepublic static java.lang.String getCellReference(Cell c)
the
- cellpublic static void getCellReference(Cell c, java.lang.StringBuffer sb)
c
- the cellsb
- string buffer