$worksheet
$worksheet :
load(\PhpOffice\PhpSpreadsheet\Reader\IReadFilter $readFilter = null, boolean $readDataOnly = false)
\PhpOffice\PhpSpreadsheet\Reader\IReadFilter | $readFilter | |
boolean | $readDataOnly |
setColumnAttributes(string $columnAddress, array $columnAttributes)
Set Worksheet column attributes by attributes array passed.
string | $columnAddress | A, B, ... DX, ... |
array | $columnAttributes | array of attributes (indexes are attribute name, values are value) 'xfIndex', 'visible', 'collapsed', 'outlineLevel', 'width', ... ? |
setRowAttributes(integer $rowNumber, array $rowAttributes)
Set Worksheet row attributes by attributes array passed.
integer | $rowNumber | 1, 2, 3, ... 99, ... |
array | $rowAttributes | array of attributes (indexes are attribute name, values are value) 'xfIndex', 'visible', 'collapsed', 'outlineLevel', 'rowHeight', ... ? |
isFilteredColumn(\PhpOffice\PhpSpreadsheet\Reader\IReadFilter $readFilter, $columnCoordinate, array $rowsAttributes)
\PhpOffice\PhpSpreadsheet\Reader\IReadFilter | $readFilter | |
$columnCoordinate | ||
array | $rowsAttributes |
isFilteredRow(\PhpOffice\PhpSpreadsheet\Reader\IReadFilter $readFilter, $rowCoordinate, array $columnsAttributes)
\PhpOffice\PhpSpreadsheet\Reader\IReadFilter | $readFilter | |
$rowCoordinate | ||
array | $columnsAttributes |