Example usage for Java org.apache.poi.ss.util CellReference fields, constructors, methods, implement or subclass
The text is from its open source code.
NameType | classifyCellReference(String str, SpreadsheetVersion ssVersion) Classifies an identifier as either a simple (2D) cell reference or a named range name |
int | convertColStringToIndex(String ref) takes in a column reference portion of a CellRef and converts it from ALPHA-26 number format to 0-based base 10. |
String | convertNumToColString(int col) Takes in a 0-based base-10 column and returns a ALPHA-26 representation. |
boolean | equals(Object o) Checks whether this cell reference is equal to another object. |
String | formatAsString() Returns a text representation of this cell reference. |
String[] | getCellRefParts() Returns the three parts of the cell reference, the Sheet name (or null if none supplied), the 1 based row number, and the A based column letter. |
short | getCol() |
int | getRow() |
String | getSheetName() |