|
||||||||||
| PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
| SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD | |||||||||
System.Objectxl.CellReferenceHelper
Exposes some cell reference helper methods to the public interface. This class merely delegates to the internally used reference helper
| Method Summary | |
static void |
getCellReference(int column,
boolean colabs, int row, boolean rowabs,
System.Text.StringBuilder buf)
Overloaded method which prepends $ for absolute reference |
static System.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, System.Text.StringBuilder buf)
Gets the fully qualified cell reference given the column, row external sheet reference etc |
static System.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,
System.Text.StringBuilder buf)
Gets the fully qualified cell reference given the column, row external sheet reference etc |
static System.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, System.Text.StringBuilder buf)
Gets the fully qualified cell reference given the column, row external sheet reference etc |
static void |
getCellReference(int column,
int row, System.Text.StringBuilder buf)
Appends the cell reference for the column and row passed in to the string buffer |
static int |
getColumn(System.String s)
Gets the columnn number of the string cell reference |
static System.String |
getColumnReference(int c)
Gets the column letter corresponding to the 0-based column number |
static int |
getRow(System.String s)
Gets the row number of the cell reference |
static System.String |
getSheet(System.String ref)
Gets the sheet name from the cell reference string |
static boolean |
isColumnRelative(System.String s)
Sees if the column component is relative or not |
static boolean |
isRowRelative(System.String s)
Sees if the row component is relative or not |
| Methods inherited from class System.Object |
equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
| Method Detail |
public static void getCellReference(int column,
int row,
System.Text.StringBuilder buf)
column - the columnrow - the rowbuf
- the string buffer to appendpublic static void getCellReference(int column,
boolean colabs,
int row,
boolean rowabs,
System.Text.StringBuilder 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 System.String getCellReference(int column,
int row)
column - the columnrow - the row public static int getColumn(System.String s)
s - the string to parse public static System.String getColumnReference(int c)
c - the column number public static int getRow(System.String s)
s - the cell reference public static boolean isColumnRelative(System.String s)
s - the cell public static boolean isRowRelative(System.String s)
s - the cell public static void getCellReference(int sheet,
int column,
int row,
Workbook workbook,
System.Text.StringBuilder 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,
System.Text.StringBuilder 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,
System.Text.StringBuilder 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 System.String getCellReference(int sheet,
int column,
int row,
Workbook workbook)
sheet - the sheetcolumn - the
columnrow - the rowworkbook - the workbook public static System.String getCellReference(int sheet,
int column,
int row,
WritableWorkbook workbook)
sheet - the sheetcolumn - the
columnrow - the rowworkbook - the workbook public static System.String getSheet(System.String ref)
ref - the cell reference
|
||||||||||
| PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
| SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD | |||||||||