Properties

$worksheet

$worksheet : 

Type

$worksheetXml

$worksheetXml : 

Type

Methods

__construct()

__construct(\PhpOffice\PhpSpreadsheet\Worksheet\Worksheet  $workSheet, \SimpleXMLElement  $worksheetXml = null) 

Parameters

\PhpOffice\PhpSpreadsheet\Worksheet\Worksheet $workSheet
\SimpleXMLElement $worksheetXml

boolean()

boolean(  $value) 

Parameters

$value

setColumnAttributes()

setColumnAttributes(string  $columnAddress, array  $columnAttributes) 

Set Worksheet column attributes by attributes array passed.

Parameters

string $columnAddress

A, B, ... DX, ...

array $columnAttributes

array of attributes (indexes are attribute name, values are value) 'xfIndex', 'visible', 'collapsed', 'outlineLevel', 'width', ... ?

setRowAttributes()

setRowAttributes(integer  $rowNumber, array  $rowAttributes) 

Set Worksheet row attributes by attributes array passed.

Parameters

integer $rowNumber

1, 2, 3, ... 99, ...

array $rowAttributes

array of attributes (indexes are attribute name, values are value) 'xfIndex', 'visible', 'collapsed', 'outlineLevel', 'rowHeight', ... ?

isFilteredColumn()

isFilteredColumn(\PhpOffice\PhpSpreadsheet\Reader\IReadFilter  $readFilter,   $columnCoordinate, array  $rowsAttributes) 

Parameters

\PhpOffice\PhpSpreadsheet\Reader\IReadFilter $readFilter
$columnCoordinate
array $rowsAttributes

readColumnAttributes()

readColumnAttributes(\SimpleXMLElement  $worksheetCols,   $readDataOnly) 

Parameters

\SimpleXMLElement $worksheetCols
$readDataOnly

readColumnRangeAttributes()

readColumnRangeAttributes(\SimpleXMLElement  $column,   $readDataOnly) 

Parameters

\SimpleXMLElement $column
$readDataOnly

isFilteredRow()

isFilteredRow(\PhpOffice\PhpSpreadsheet\Reader\IReadFilter  $readFilter,   $rowCoordinate, array  $columnsAttributes) 

Parameters

\PhpOffice\PhpSpreadsheet\Reader\IReadFilter $readFilter
$rowCoordinate
array $columnsAttributes

readRowAttributes()

readRowAttributes(\SimpleXMLElement  $worksheetRow,   $readDataOnly) 

Parameters

\SimpleXMLElement $worksheetRow
$readDataOnly