Search moodle.org's
Developer Documentation

See Release Notes

  • Bug fixes for general core bugs in 3.10.x will end 8 November 2021 (12 months).
  • Bug fixes for security issues in 3.10.x will end 9 May 2022 (18 months).
  • PHP version: minimum PHP 7.2.0 Note: minimum PHP version has increased since Moodle 3.8. PHP 7.3.x and 7.4.x are supported too.

Differences Between: [Versions 310 and 311] [Versions 310 and 400] [Versions 310 and 401]

(no description)

File Size: 80 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

Class CellHelper
This class provides helper functions when working with cells

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