See Release Notes
Long Term Support Release
Differences Between: [Versions 310 and 401] [Versions 39 and 401]
(no description)
File Size: | 80 lines (3 kb) |
Included or required: | 0 times |
Referenced: | 0 times |
Includes or requires: | 0 files |
CellHelper:: (2 methods):
getColumnIndexFromCellIndex()
isValidCellIndex()
Class: CellHelper - X-Ref
Class CellHelpergetColumnIndexFromCellIndex($cellIndex) X-Ref |
Returns the base 10 column index associated to the cell index (base 26). Excel uses A to Z letters for column indexing, where A is the 1st column, Z is the 26th and AA is the 27th. The mapping is zero based, so that A1 maps to 0, B2 maps to 1, Z13 to 25 and AA4 to 26. param: string $cellIndex The Excel cell index ('A1', 'BC13', ...) return: int |
isValidCellIndex($cellIndex) X-Ref |
Returns whether a cell index is valid, in an Excel world. To be valid, the cell index should start with capital letters and be followed by numbers. There can only be 3 letters, as there can only be 16,384 rows, which is equivalent to 'XFE'. param: string $cellIndex The Excel cell index ('A1', 'BC13', ...) return: bool |