Validations
in package
Table of Contents
Constants
- SETMAXCOL = 'A${1}:' . \PhpOffice\PhpSpreadsheet\Cell\AddressRange::MAX_COLUMN . '${2}'
- SETMAXROW = '${1}1:${2}' . \PhpOffice\PhpSpreadsheet\Cell\AddressRange::MAX_ROW
Methods
- definedNameToCoordinate() : string
- validateCellAddress() : string
- Validate a cell address.
- validateCellOrCellRange() : string
- Validate a cell address or cell range.
- validateCellRange() : string
- Validate a cell range.
Constants
SETMAXCOL
private
mixed
SETMAXCOL
= 'A${1}:' . \PhpOffice\PhpSpreadsheet\Cell\AddressRange::MAX_COLUMN . '${2}'
SETMAXROW
private
mixed
SETMAXROW
= '${1}1:${2}' . \PhpOffice\PhpSpreadsheet\Cell\AddressRange::MAX_ROW
Methods
definedNameToCoordinate()
public
static definedNameToCoordinate(string $coordinate, Worksheet $worksheet) : string
Parameters
- $coordinate : string
- $worksheet : Worksheet
Return values
stringvalidateCellAddress()
Validate a cell address.
public
static validateCellAddress(null|array{0: int, 1: int}|CellAddress|string $cellAddress) : string
Parameters
- $cellAddress : null|array{0: int, 1: int}|CellAddress|string
-
Coordinate of the cell as a string, eg: 'C5'; or as an array of [$columnIndex, $row] (e.g. [3, 5]), or a CellAddress object.
Return values
stringvalidateCellOrCellRange()
Validate a cell address or cell range.
public
static validateCellOrCellRange(AddressRange<string|int, CellAddress>|array{0: int, 1: int, 2: int, 3: int}|array{0: int, 1: int}|CellAddress|int|string $cellRange) : string
Parameters
- $cellRange : AddressRange<string|int, CellAddress>|array{0: int, 1: int, 2: int, 3: int}|array{0: int, 1: int}|CellAddress|int|string
-
Coordinate of the cells as a string, eg: 'C5:F12'; or as an array of [$fromColumnIndex, $fromRow, $toColumnIndex, $toRow] (e.g. [3, 5, 6, 12]), or as a CellAddress or AddressRange object.
Return values
stringvalidateCellRange()
Validate a cell range.
public
static validateCellRange(AddressRange<string|int, CellAddress>|array{0: int, 1: int, 2: int, 3: int}|array{0: int, 1: int}|string $cellRange) : string
Parameters
- $cellRange : AddressRange<string|int, CellAddress>|array{0: int, 1: int, 2: int, 3: int}|array{0: int, 1: int}|string
-
Coordinate of the cells as a string, eg: 'C5:F12'; or as an array of [$fromColumnIndex, $fromRow, $toColumnIndex, $toRow] (e.g. [3, 5, 6, 12]), or as an AddressRange object.