\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

$parentWriter

$parentWriter : \PhpOffice\PhpSpreadsheet\Writer\Xlsx

Parent Xlsx object.

Type

Xlsx

Methods

getParentWriter()

getParentWriter() : \PhpOffice\PhpSpreadsheet\Writer\Xlsx

Get parent Xlsx object.

Returns

\PhpOffice\PhpSpreadsheet\Writer\Xlsx —

__construct()

__construct(\PhpOffice\PhpSpreadsheet\Writer\Xlsx  $pWriter) : mixed

Set parent Xlsx object.

Parameters

\PhpOffice\PhpSpreadsheet\Writer\Xlsx $pWriter

Returns

mixed —

writeWorkbook()

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

Write workbook to XML format.

Parameters

\PhpOffice\PhpSpreadsheet\Spreadsheet $spreadsheet
bool $recalcRequired

Indicate whether formulas should be recalculated before writing

Returns

string —

XML Output

writeFileVersion()

writeFileVersion(\PhpOffice\PhpSpreadsheet\Shared\XMLWriter  $objWriter) : void

Write file version.

Parameters

\PhpOffice\PhpSpreadsheet\Shared\XMLWriter $objWriter

XML Writer

writeWorkbookPr()

writeWorkbookPr(\PhpOffice\PhpSpreadsheet\Shared\XMLWriter  $objWriter) : void

Write WorkbookPr.

Parameters

\PhpOffice\PhpSpreadsheet\Shared\XMLWriter $objWriter

XML Writer

writeBookViews()

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

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) : void

Write WorkbookProtection.

Parameters

\PhpOffice\PhpSpreadsheet\Shared\XMLWriter $objWriter

XML Writer

\PhpOffice\PhpSpreadsheet\Spreadsheet $spreadsheet

writeCalcPr()

writeCalcPr(\PhpOffice\PhpSpreadsheet\Shared\XMLWriter  $objWriter, bool  $recalcRequired = true) : void

Write calcPr.

Parameters

\PhpOffice\PhpSpreadsheet\Shared\XMLWriter $objWriter

XML Writer

bool $recalcRequired

Indicate whether formulas should be recalculated before writing

writeSheets()

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

Write sheets.

Parameters

\PhpOffice\PhpSpreadsheet\Shared\XMLWriter $objWriter

XML Writer

\PhpOffice\PhpSpreadsheet\Spreadsheet $spreadsheet

writeSheet()

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

Write sheet.

Parameters

\PhpOffice\PhpSpreadsheet\Shared\XMLWriter $objWriter

XML Writer

string $pSheetname

Sheet name

int $pSheetId

Sheet id

int $pRelId

Relationship ID

string $sheetState

Sheet state (visible, hidden, veryHidden)