|
| | __construct (Spreadsheet $spreadsheet) |
| | Create a new Xlsx Writer.
|
| |
| | getBordersHashTable () |
| | Get Borders HashTable.
|
| |
| | getDiskCachingDirectory () |
| | Get disk caching directory.
|
| |
| | getDrawingHashTable () |
| | Get PhpOffice::PhpSpreadsheet::Worksheet::Worksheet::BaseDrawing HashTable.
|
| |
|
| getExplicitStyle0 () |
| |
| | getFillHashTable () |
| | Get Fill HashTable.
|
| |
| | getFontHashTable () |
| | Get PhpOffice\PhpSpreadsheet\Style\Font HashTable.
|
| |
| | getIncludeCharts () |
| | Write charts in workbook?
|
| |
| | getNumFmtHashTable () |
| | Get NumberFormat HashTable.
|
| |
|
| getOffice2003Compatibility () |
| | Get Office2003 compatibility.
|
| |
| | getPreCalculateFormulas () |
| | 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.
|
| |
|
| getSpreadsheet () |
| | Get Spreadsheet object.
|
| |
| | getStringTable () |
| | Get string table.
|
| |
| | getStyleHashTable () |
| | Get Style HashTable.
|
| |
| | getStylesConditionalHashTable () |
| | Get Conditional HashTable.
|
| |
| | getUseDiskCaching () |
| | Get use disk caching where possible?
|
| |
|
| getWriterPartChart () |
| |
|
| getWriterPartComments () |
| |
|
| getWriterPartContentTypes () |
| |
|
| getWriterPartDocProps () |
| |
|
| getWriterPartDrawing () |
| |
|
| getWriterPartRels () |
| |
|
| getWriterPartRelsRibbon () |
| |
|
| getWriterPartRelsVBA () |
| |
|
| getWriterPartStringTable () |
| |
|
| getWriterPartStyle () |
| |
|
| getWriterPartTable () |
| |
|
| getWriterPartTheme () |
| |
|
| getWriterPartWorkbook () |
| |
|
| getWriterPartWorksheet () |
| |
| | openFileHandle ($filename) |
| | Open file handle.
|
| |
| | save ($filename, int $flags=0) |
| | Save PhpSpreadsheet to file.
|
| |
|
| setExplicitStyle0 (bool $explicitStyle0) |
| | This may be useful if non-default Alignment is part of default style and you think you might want to open the spreadsheet with LibreOffice or Gnumeric.
|
| |
| | setForceFullCalc (?bool $forceFullCalc) |
| | If this is set when a spreadsheet is opened, values may not be automatically re-calculated, and a button will be available to force re-calculation.
|
| |
| | setIncludeCharts (bool $includeCharts) |
| | Set write charts in workbook Set to true, to advise the Writer to include any charts that exist in the PhpSpreadsheet object.
|
| |
| | setOffice2003Compatibility (bool $office2003compatibility) |
| | Set Office2003 compatibility.
|
| |
| | setPreCalculateFormulas (bool $precalculateFormulas) |
| | 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.
|
| |
| | setSpreadsheet (Spreadsheet $spreadsheet) |
| | Set Spreadsheet object.
|
| |
|
| setUseCSEArrays (?bool $useCSEArrays) |
| |
| | setUseDiskCaching (bool $useDiskCache, ?string $cacheDirectory=null) |
| | Set use disk caching where possible?
|
| |
|
| useDynamicArrays () |
| |
| PhpOffice\PhpSpreadsheet\Writer\BaseWriter::getPreCalculateFormulas |
( |
| ) |
|
|
inherited |
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.
Implements PhpOffice\PhpSpreadsheet\Writer\IWriter.
| PhpOffice\PhpSpreadsheet\Writer\Xlsx::setForceFullCalc |
( |
?bool | $forceFullCalc | ) |
|
If this is set when a spreadsheet is opened, values may not be automatically re-calculated, and a button will be available to force re-calculation.
This may apply to all spreadsheets open at that time. If null, this will be set to the opposite of $preCalculateFormulas. It is likely that false is the desired setting, although cases have been reported where true is required (issue #456). Nevertheless, default is set to false in PhpSpreadsheet 4.0.0.
1.13.2