XlsxComponent
extends AbstractExportFile
in package
Table of Contents
Properties
- $hasLineColors : mixed
- $currentRow : mixed
- $sheet : mixed
- $spreadsheet : mixed
Methods
- __construct() : mixed
- getFileType() : string
- saveFile() : string
- Saves the XLSX file with a unique filename.
- writeLine() : void
- decrementColumnName() : string
- incrementColumnName() : string
- isLastRow() : bool
- This method is used in order to not paint the negative values in the last row in red, because the whole row has red background. We need to change it if we add some more rows.
Properties
$hasLineColors
public
mixed
$hasLineColors
$currentRow
protected
mixed
$currentRow
= 1
$sheet
protected
mixed
$sheet
$spreadsheet
protected
mixed
$spreadsheet
Methods
__construct()
public
__construct(bool $hasLineColors) : mixed
Parameters
- $hasLineColors : bool
getFileType()
public
getFileType() : string
Return values
stringsaveFile()
Saves the XLSX file with a unique filename.
public
saveFile(string $filename) : string
Parameters
- $filename : string
Tags
Return values
stringwriteLine()
public
writeLine(mixed $line[, mixed $file = null ][, mixed $lineColor = null ][, mixed $handler = null ]) : void
Parameters
- $line : mixed
- $file : mixed = null
- $lineColor : mixed = null
- $handler : mixed = null
decrementColumnName()
private
decrementColumnName(mixed $columnName) : string
Parameters
- $columnName : mixed
Return values
stringincrementColumnName()
private
incrementColumnName(mixed $columnName) : string
Parameters
- $columnName : mixed
Return values
stringisLastRow()
This method is used in order to not paint the negative values in the last row in red, because the whole row has red background. We need to change it if we add some more rows.
private
isLastRow(mixed $handler) : bool
1st row-> headers, 5 rows x 12 months -> 60, total filed, total proofs, total VJ and difference between totals (2) -> 66 rows
Parameters
- $handler : mixed