ColumnAndRowAttributes
extends BaseParserClass
in package
Table of Contents
Properties
- $worksheet : Worksheet
- $worksheetXml : SimpleXMLElement|null
Methods
- __construct() : mixed
- load() : void
- boolean() : bool
- isFilteredColumn() : bool
- isFilteredRow() : bool
- readColumnAttributes() : array<string|int, mixed>
- readColumnRangeAttributes() : array<string|int, mixed>
- readRowAttributes() : array<string|int, mixed>
- setColumnAttributes() : void
- Set Worksheet column attributes by attributes array passed.
- setRowAttributes() : void
- Set Worksheet row attributes by attributes array passed.
Properties
$worksheet
private
Worksheet
$worksheet
$worksheetXml
private
SimpleXMLElement|null
$worksheetXml
Methods
__construct()
public
__construct(Worksheet $workSheet[, SimpleXMLElement|null $worksheetXml = null ]) : mixed
Parameters
- $workSheet : Worksheet
- $worksheetXml : SimpleXMLElement|null = null
load()
public
load([IReadFilter|null $readFilter = null ][, bool $readDataOnly = false ]) : void
Parameters
- $readFilter : IReadFilter|null = null
- $readDataOnly : bool = false
boolean()
protected
static boolean(mixed $value) : bool
Parameters
- $value : mixed
Return values
boolisFilteredColumn()
private
isFilteredColumn(IReadFilter $readFilter, string $columnCoordinate, array<string|int, mixed> $rowsAttributes) : bool
Parameters
- $readFilter : IReadFilter
- $columnCoordinate : string
- $rowsAttributes : array<string|int, mixed>
Return values
boolisFilteredRow()
private
isFilteredRow(IReadFilter $readFilter, int $rowCoordinate, array<string|int, mixed> $columnsAttributes) : bool
Parameters
- $readFilter : IReadFilter
- $rowCoordinate : int
- $columnsAttributes : array<string|int, mixed>
Return values
boolreadColumnAttributes()
private
readColumnAttributes(SimpleXMLElement $worksheetCols, bool $readDataOnly) : array<string|int, mixed>
Parameters
- $worksheetCols : SimpleXMLElement
- $readDataOnly : bool
Return values
array<string|int, mixed>readColumnRangeAttributes()
private
readColumnRangeAttributes(SimpleXMLElement|null $column, bool $readDataOnly) : array<string|int, mixed>
Parameters
- $column : SimpleXMLElement|null
- $readDataOnly : bool
Return values
array<string|int, mixed>readRowAttributes()
private
readRowAttributes(SimpleXMLElement $worksheetRow, bool $readDataOnly) : array<string|int, mixed>
Parameters
- $worksheetRow : SimpleXMLElement
- $readDataOnly : bool
Return values
array<string|int, mixed>setColumnAttributes()
Set Worksheet column attributes by attributes array passed.
private
setColumnAttributes(string $columnAddress, array<string|int, mixed> $columnAttributes) : void
Parameters
- $columnAddress : string
-
A, B, ... DX, ...
- $columnAttributes : array<string|int, mixed>
-
array of attributes (indexes are attribute name, values are value) 'xfIndex', 'visible', 'collapsed', 'outlineLevel', 'width', ... ?
setRowAttributes()
Set Worksheet row attributes by attributes array passed.
private
setRowAttributes(int $rowNumber, array<string|int, mixed> $rowAttributes) : void
Parameters
- $rowNumber : int
-
1, 2, 3, ... 99, ...
- $rowAttributes : array<string|int, mixed>
-
array of attributes (indexes are attribute name, values are value) 'xfIndex', 'visible', 'collapsed', 'outlineLevel', 'rowHeight', ... ?