Search moodle.org's
Developer Documentation
Developer Documentation
- Bug fixes for general core bugs in 4.3.x will end 7 October 2024 (12 months).
- Bug fixes for security issues in 4.3.x will end 21 April 2025 (18 months).
- PHP version: minimum PHP 8.0.0 Note: minimum PHP version has increased since Moodle 4.1. PHP 8.2.x is supported too.
/lib/openspout/src/Reader/XLSX/Helper/ -> CellHelper.php (source)
(no description)
| File Size: | 85 lines (3 kb) |
| Included or required: | 0 times |
| Referenced: | 0 times |
| Includes or requires: | 0 files |
Defines 1 class
CellHelper:: (2 methods):
getColumnIndexFromCellIndex()
isValidCellIndex()
Class: CellHelper - X-Ref
| getColumnIndexFromCellIndex(string $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', ...) |
| isValidCellIndex(string $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', ...) |
