Search moodle.org's
Developer Documentation

See Release Notes
Long Term Support Release

  • Bug fixes for general core bugs in 3.9.x will end* 10 May 2021 (12 months).
  • Bug fixes for security issues in 3.9.x will end* 8 May 2023 (36 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.
/lib/spout/src/Spout/Writer/Common/Helper/ -> CellHelper.php (source)

[Source view]

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

(no description)

File Size: 45 lines (2 kb)
Included or required:0 times
Referenced: 0 times
Includes or requires: 0 files

Defines 1 class

CellHelper:: (1 method):
  getCellIndexFromColumnIndex()


Class: CellHelper  - X-Ref

Class CellHelper
This class provides helper functions when working with cells

getCellIndexFromColumnIndex($columnIndex)   X-Ref
Returns the cell index (base 26) associated to the base 10 column index.
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 0 maps to A, B maps to 1, Z to 25 and AA to 26.

param: int $columnIndex The Excel column index (0, 42, ...)
return: string The associated cell index ('A', 'BC', ...)