Documentation

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

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 ][, bool $ignoreRowsWithNoCells = false ]) : void
Parameters
$readFilter : IReadFilter|null = null
$readDataOnly : bool = false
$ignoreRowsWithNoCells : bool = false

boolean()

protected static boolean(mixed $value) : bool
Parameters
$value : mixed
Return values
bool

isFilteredColumn()

private isFilteredColumn(IReadFilter $readFilter, string $columnCoordinate, array<string|int, mixed> $rowsAttributes) : bool
Parameters
$readFilter : IReadFilter
$columnCoordinate : string
$rowsAttributes : array<string|int, mixed>
Return values
bool

isFilteredRow()

private isFilteredRow(IReadFilter $readFilter, int $rowCoordinate, array<string|int, mixed> $columnsAttributes) : bool
Parameters
$readFilter : IReadFilter
$rowCoordinate : int
$columnsAttributes : array<string|int, mixed>
Return values
bool

readColumnAttributes()

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, bool $ignoreRowsWithNoCells, bool $readFilterIsNotNull) : array<string|int, mixed>
Parameters
$worksheetRow : SimpleXMLElement
$readDataOnly : bool
$ignoreRowsWithNoCells : bool
$readFilterIsNotNull : bool
Return values
array<string|int, mixed>

setColumnAttributes()

Set Worksheet column attributes by attributes array passed.

private setColumnAttributes(string $columnAddress, array{xfIndex?: int, visible?: bool, collapsed?: bool, collapsed?: bool, outlineLevel?: int, rowHeight?: float, width?: int} $columnAttributes) : void
Parameters
$columnAddress : string

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

$columnAttributes : array{xfIndex?: int, visible?: bool, collapsed?: bool, collapsed?: bool, outlineLevel?: int, rowHeight?: float, width?: int}

array of attributes (indexes are attribute name, values are value)

setRowAttributes()

Set Worksheet row attributes by attributes array passed.

private setRowAttributes(int $rowNumber, array{xfIndex?: int, visible?: bool, collapsed?: bool, collapsed?: bool, outlineLevel?: int, rowHeight?: float} $rowAttributes) : void
Parameters
$rowNumber : int

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

$rowAttributes : array{xfIndex?: int, visible?: bool, collapsed?: bool, collapsed?: bool, outlineLevel?: int, rowHeight?: float}

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


        

        
    




    

    

                                

                

                                
    

        On this page

        
    


                

                            

            

    

        

            
Search results