CellAddress
Table of Contents
- $cellAddress : string
- $columnId : int
- $columnName : string
- $rowId : int
- $worksheet : Worksheet|null
- __construct() : mixed
- __toString() : mixed
- The returned address string will contain the worksheet name as well, if available, (ie. if a Worksheet was provided to the constructor).
- cellAddress() : string
- The returned address string will contain just the column/row address, (even if a Worksheet was provided to the constructor).
- columnId() : int
- columnName() : string
- fromCellAddress() : self
- fromColumnAndRow() : self
- fromColumnRowArray() : self
- fullCellAddress() : string
- The returned address string will contain the worksheet name as well, if available, (ie. if a Worksheet was provided to the constructor).
- nextColumn() : self
- nextRow() : self
- previousColumn() : self
- previousRow() : self
- rowId() : int
- worksheet() : Worksheet|null
- validateColumnAndRow() : void
Properties
$cellAddress
protected
string
$cellAddress
$columnId
protected
int
$columnId
$columnName
protected
string
$columnName
$rowId
protected
int
$rowId
$worksheet
protected
Worksheet|null
$worksheet
Methods
__construct()
public
__construct(string $cellAddress[, Worksheet|null $worksheet = null ]) : mixed
Parameters
- $cellAddress : string
- $worksheet : Worksheet|null = null
Return values
mixed —__toString()
The returned address string will contain the worksheet name as well, if available, (ie. if a Worksheet was provided to the constructor).
public
__toString() : mixed
e.g. "'Mark''s Worksheet'!C5".
Return values
mixed —cellAddress()
The returned address string will contain just the column/row address, (even if a Worksheet was provided to the constructor).
public
cellAddress() : string
e.g. "C5".
Return values
string —columnId()
public
columnId() : int
Return values
int —columnName()
public
columnName() : string
Return values
string —fromCellAddress()
public
static fromCellAddress(mixed $cellAddress[, Worksheet|null $worksheet = null ]) : self
Parameters
- $cellAddress : mixed
- $worksheet : Worksheet|null = null
Return values
self —fromColumnAndRow()
public
static fromColumnAndRow(mixed $columnId, mixed $rowId[, Worksheet|null $worksheet = null ]) : self
Parameters
- $columnId : mixed
- $rowId : mixed
- $worksheet : Worksheet|null = null
Return values
self —fromColumnRowArray()
public
static fromColumnRowArray(array<string|int, mixed> $array[, Worksheet|null $worksheet = null ]) : self
Parameters
- $array : array<string|int, mixed>
- $worksheet : Worksheet|null = null
Return values
self —fullCellAddress()
The returned address string will contain the worksheet name as well, if available, (ie. if a Worksheet was provided to the constructor).
public
fullCellAddress() : string
e.g. "'Mark''s Worksheet'!C5".
Return values
string —nextColumn()
public
nextColumn([int $offset = 1 ]) : self
Parameters
- $offset : int = 1
Return values
self —nextRow()
public
nextRow([int $offset = 1 ]) : self
Parameters
- $offset : int = 1
Return values
self —previousColumn()
public
previousColumn([int $offset = 1 ]) : self
Parameters
- $offset : int = 1
Return values
self —previousRow()
public
previousRow([int $offset = 1 ]) : self
Parameters
- $offset : int = 1
Return values
self —rowId()
public
rowId() : int
Return values
int —worksheet()
public
worksheet() : Worksheet|null
Return values
Worksheet|null —validateColumnAndRow()
private
static validateColumnAndRow(mixed $columnId, mixed $rowId) : void
Parameters
- $columnId : mixed
- $rowId : mixed