Box\Spout\Reader\XLSX\Helper\CellHelper Class Reference

Static Public Member Functions
static	getColumnIndexFromCellIndex ($cellIndex)
	Returns the base 10 column index associated to the cell index (base 26).

Static Protected Member Functions
static	isValidCellIndex ($cellIndex)
	Returns whether a cell index is valid, in an Excel world.

Member Function Documentation

getColumnIndexFromCellIndex()

static Box\Spout\Reader\XLSX\Helper\CellHelper::getColumnIndexFromCellIndex ( $cellIndex )

static

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.

Parameters

string

$cellIndex

The Excel cell index ('A1', 'BC13', ...)

Exceptions

Box\Spout\Common\Exception\InvalidArgumentException

When the given cell index is invalid

Return values

int

isValidCellIndex()

static Box\Spout\Reader\XLSX\Helper\CellHelper::isValidCellIndex ( $cellIndex )

staticprotected

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'.

Parameters

string

$cellIndex

The Excel cell index ('A1', 'BC13', ...)

Return values

bool

---

The documentation for this class was generated from the following file:

• lib/spout/src/Spout/Reader/XLSX/Helper/CellHelper.php