| [ Index ] |
PHP Cross Reference of Unnamed Project |
[Source view] [Print] [Project Stats]
(no description)
| File Size: | 103 lines (4 kb) |
| Included or required: | 0 times |
| Referenced: | 0 times |
| Includes or requires: | 0 files |
CellHelper:: (3 methods):
fillMissingArrayIndexes()
getColumnIndexFromCellIndex()
isValidCellIndex()
Class: CellHelper - X-Ref
Class CellHelper| fillMissingArrayIndexes($dataArray, $fillValue = '') X-Ref |
| Fills the missing indexes of an array with a given value. For instance, $dataArray = []; $a[1] = 1; $a[3] = 3; Calling fillMissingArrayIndexes($dataArray, 'FILL') will return this array: ['FILL', 1, 'FILL', 3] param: array $dataArray The array to fill param: string|void $fillValue optional return: array |
| getColumnIndexFromCellIndex($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 |
| Generated: Thu Aug 11 10:00:09 2016 | Cross-referenced by PHPXref 0.7.1 |