\PhpOffice\PhpSpreadsheet\Writer\XlsxWorkbook

Summary

Methods
Properties
Constants
getParentWriter()
__construct()
writeWorkbook()
No public properties found
No constants found
No protected methods found
No protected properties found
N/A
writeFileVersion()
writeWorkbookPr()
writeBookViews()
writeWorkbookProtection()
writeCalcPr()
writeSheets()
writeSheet()
$parentWriter
N/A

Properties

Methods

writeWorkbook()

writeWorkbook(\PhpOffice\PhpSpreadsheet\Spreadsheet  $spreadsheet, boolean  $recalcRequired = false) : string

Write workbook to XML format.

Parameters

\PhpOffice\PhpSpreadsheet\Spreadsheet $spreadsheet
boolean $recalcRequired

Indicate whether formulas should be recalculated before writing

Returns

string —

XML Output

writeBookViews()

writeBookViews(\PhpOffice\PhpSpreadsheet\Shared\XMLWriter  $objWriter, \PhpOffice\PhpSpreadsheet\Spreadsheet  $spreadsheet) 

Write BookViews.

Parameters

\PhpOffice\PhpSpreadsheet\Shared\XMLWriter $objWriter

XML Writer

\PhpOffice\PhpSpreadsheet\Spreadsheet $spreadsheet

writeWorkbookProtection()

writeWorkbookProtection(\PhpOffice\PhpSpreadsheet\Shared\XMLWriter  $objWriter, \PhpOffice\PhpSpreadsheet\Spreadsheet  $spreadsheet) 

Write WorkbookProtection.

Parameters

\PhpOffice\PhpSpreadsheet\Shared\XMLWriter $objWriter

XML Writer

\PhpOffice\PhpSpreadsheet\Spreadsheet $spreadsheet

writeCalcPr()

writeCalcPr(\PhpOffice\PhpSpreadsheet\Shared\XMLWriter  $objWriter, boolean  $recalcRequired = true) 

Write calcPr.

Parameters

\PhpOffice\PhpSpreadsheet\Shared\XMLWriter $objWriter

XML Writer

boolean $recalcRequired

Indicate whether formulas should be recalculated before writing

writeSheets()

writeSheets(\PhpOffice\PhpSpreadsheet\Shared\XMLWriter  $objWriter, \PhpOffice\PhpSpreadsheet\Spreadsheet  $spreadsheet) 

Write sheets.

Parameters

\PhpOffice\PhpSpreadsheet\Shared\XMLWriter $objWriter

XML Writer

\PhpOffice\PhpSpreadsheet\Spreadsheet $spreadsheet

writeSheet()

writeSheet(\PhpOffice\PhpSpreadsheet\Shared\XMLWriter  $objWriter, string  $pSheetname, integer  $pSheetId = 1, integer  $pRelId = 1, string  $sheetState = 'visible') 

Write sheet.

Parameters

\PhpOffice\PhpSpreadsheet\Shared\XMLWriter $objWriter

XML Writer

string $pSheetname

Sheet name

integer $pSheetId

Sheet id

integer $pRelId

Relationship ID

string $sheetState

Sheet state (visible, hidden, veryHidden)