Documentation

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
string

validateCellAddress()

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
string

validateCellOrCellRange()

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
string

validateCellRange()

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.

Return values
string

        
On this page

Search results