$includeCharts
$includeCharts : boolean
Write charts that are defined in the workbook? Identifies whether the Writer should write definitions for any charts that exist in the PhpSpreadsheet object;.
$writerParts : array<mixed,\PhpOffice\PhpSpreadsheet\Writer\Xlsx\WriterPart>
Private writer parts.
$spreadSheet : \PhpOffice\PhpSpreadsheet\Spreadsheet
Private Spreadsheet.
$stylesConditionalHashTable : \PhpOffice\PhpSpreadsheet\HashTable
Private unique Conditional HashTable.
$styleHashTable : \PhpOffice\PhpSpreadsheet\HashTable
Private unique Style HashTable.
$fillHashTable : \PhpOffice\PhpSpreadsheet\HashTable
Private unique Fill HashTable.
$fontHashTable : \PhpOffice\PhpSpreadsheet\HashTable
Private unique \PhpOffice\PhpSpreadsheet\Style\Font HashTable.
$bordersHashTable : \PhpOffice\PhpSpreadsheet\HashTable
Private unique Borders HashTable.
$numFmtHashTable : \PhpOffice\PhpSpreadsheet\HashTable
Private unique NumberFormat HashTable.
$drawingHashTable : \PhpOffice\PhpSpreadsheet\HashTable
Private unique \PhpOffice\PhpSpreadsheet\Worksheet\Worksheet\BaseDrawing HashTable.
setIncludeCharts(boolean $pValue) : \PhpOffice\PhpSpreadsheet\Writer\IWriter
Set write charts in workbook Set to true, to advise the Writer to include any charts that exist in the PhpSpreadsheet object.
Set to false (the default) to ignore charts.
| boolean | $pValue |
getPreCalculateFormulas() : boolean
Get Pre-Calculate Formulas flag If this is true (the default), then the writer will recalculate all formulae in a workbook when saving, so that the pre-calculated values are immediately available to MS Excel or other office spreadsheet viewer when opening the file If false, then formulae are not calculated on save. This is faster for saving in PhpSpreadsheet, but slower when opening the resulting file in MS Excel, because Excel has to recalculate the formulae itself.
setPreCalculateFormulas(boolean $pValue) : \PhpOffice\PhpSpreadsheet\Writer\IWriter
Set Pre-Calculate Formulas Set to true (the default) to advise the Writer to calculate all formulae on save Set to false to prevent precalculation of formulae on save.
| boolean | $pValue | Pre-Calculate Formulas? |
setUseDiskCaching(boolean $pValue, string $pDirectory = null) : \PhpOffice\PhpSpreadsheet\Writer\IWriter
Set use disk caching where possible?
| boolean | $pValue | |
| string | $pDirectory | Disk caching directory |
__construct(\PhpOffice\PhpSpreadsheet\Spreadsheet $spreadsheet)
Create a new Xlsx Writer.
| \PhpOffice\PhpSpreadsheet\Spreadsheet | $spreadsheet |
getWriterPart(string $pPartName) : \PhpOffice\PhpSpreadsheet\Writer\Xlsx\WriterPart
Get writer part.
| string | $pPartName | Writer part name |
getSpreadsheet() : \PhpOffice\PhpSpreadsheet\Spreadsheet
Get Spreadsheet object.
setSpreadsheet(\PhpOffice\PhpSpreadsheet\Spreadsheet $spreadsheet) : $this
Set Spreadsheet object.
| \PhpOffice\PhpSpreadsheet\Spreadsheet | $spreadsheet | PhpSpreadsheet object |
getStyleHashTable() : \PhpOffice\PhpSpreadsheet\HashTable
Get Style HashTable.
getStylesConditionalHashTable() : \PhpOffice\PhpSpreadsheet\HashTable
Get Conditional HashTable.
getFillHashTable() : \PhpOffice\PhpSpreadsheet\HashTable
Get Fill HashTable.
getFontHashTable() : \PhpOffice\PhpSpreadsheet\HashTable
Get \PhpOffice\PhpSpreadsheet\Style\Font HashTable.
getBordersHashTable() : \PhpOffice\PhpSpreadsheet\HashTable
Get Borders HashTable.
getNumFmtHashTable() : \PhpOffice\PhpSpreadsheet\HashTable
Get NumberFormat HashTable.
getDrawingHashTable() : \PhpOffice\PhpSpreadsheet\HashTable
Get \PhpOffice\PhpSpreadsheet\Worksheet\Worksheet\BaseDrawing HashTable.