|
||||||||||
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 |