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

Throws

\PhpOffice\PhpSpreadsheet\Writer\Exception

Returns

string —

XML Output

writeFileVersion()

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

Write file version.

Parameters

\PhpOffice\PhpSpreadsheet\Shared\XMLWriter $objWriter

XML Writer

Returns

mixed —

writeWorkbookPr()

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

Write WorkbookPr.

Parameters

\PhpOffice\PhpSpreadsheet\Shared\XMLWriter $objWriter

XML Writer

Returns

mixed —

writeBookViews()

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

Write BookViews.

Parameters

\PhpOffice\PhpSpreadsheet\Shared\XMLWriter $objWriter

XML Writer

\PhpOffice\PhpSpreadsheet\Spreadsheet $spreadsheet

Returns

mixed —

writeWorkbookProtection()

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

Write WorkbookProtection.

Parameters

\PhpOffice\PhpSpreadsheet\Shared\XMLWriter $objWriter

XML Writer

\PhpOffice\PhpSpreadsheet\Spreadsheet $spreadsheet

Returns

mixed —

writeCalcPr()

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

Write calcPr.

Parameters

\PhpOffice\PhpSpreadsheet\Shared\XMLWriter $objWriter

XML Writer

bool $recalcRequired

Indicate whether formulas should be recalculated before writing

Returns

mixed —

writeSheets()

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

Write sheets.

Parameters

\PhpOffice\PhpSpreadsheet\Shared\XMLWriter $objWriter

XML Writer

\PhpOffice\PhpSpreadsheet\Spreadsheet $spreadsheet

Throws

\PhpOffice\PhpSpreadsheet\Writer\Exception

Returns

mixed —

writeSheet()

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

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)

Throws

\PhpOffice\PhpSpreadsheet\Writer\Exception

Returns

mixed —

writeDefinedNames()

writeDefinedNames(\PhpOffice\PhpSpreadsheet\Shared\XMLWriter  $objWriter, \PhpOffice\PhpSpreadsheet\Spreadsheet  $spreadsheet) : mixed

Write Defined Names.

Parameters

\PhpOffice\PhpSpreadsheet\Shared\XMLWriter $objWriter

XML Writer

\PhpOffice\PhpSpreadsheet\Spreadsheet $spreadsheet

Throws

\PhpOffice\PhpSpreadsheet\Writer\Exception

Returns

mixed —

writeNamedRanges()

writeNamedRanges(\PhpOffice\PhpSpreadsheet\Shared\XMLWriter  $objWriter, \PhpOffice\PhpSpreadsheet\Spreadsheet  $spreadsheet) : mixed

Write named ranges.

Parameters

\PhpOffice\PhpSpreadsheet\Shared\XMLWriter $objWriter

XML Writer

\PhpOffice\PhpSpreadsheet\Spreadsheet $spreadsheet

Throws

\PhpOffice\PhpSpreadsheet\Writer\Exception

Returns

mixed —

writeDefinedNameForNamedRange()

writeDefinedNameForNamedRange(\PhpOffice\PhpSpreadsheet\Shared\XMLWriter  $objWriter, \PhpOffice\PhpSpreadsheet\NamedRange  $pNamedRange) : mixed

Write Defined Name for named range.

Parameters

\PhpOffice\PhpSpreadsheet\Shared\XMLWriter $objWriter

XML Writer

\PhpOffice\PhpSpreadsheet\NamedRange $pNamedRange

Returns

mixed —

writeDefinedNameForAutofilter()

writeDefinedNameForAutofilter(\PhpOffice\PhpSpreadsheet\Shared\XMLWriter  $objWriter, \PhpOffice\PhpSpreadsheet\Worksheet\Worksheet  $pSheet, int  $pSheetId) : mixed

Write Defined Name for autoFilter.

Parameters

\PhpOffice\PhpSpreadsheet\Shared\XMLWriter $objWriter

XML Writer

\PhpOffice\PhpSpreadsheet\Worksheet\Worksheet $pSheet
int $pSheetId

Returns

mixed —

writeDefinedNameForPrintTitles()

writeDefinedNameForPrintTitles(\PhpOffice\PhpSpreadsheet\Shared\XMLWriter  $objWriter, \PhpOffice\PhpSpreadsheet\Worksheet\Worksheet  $pSheet, int  $pSheetId) : mixed

Write Defined Name for PrintTitles.

Parameters

\PhpOffice\PhpSpreadsheet\Shared\XMLWriter $objWriter

XML Writer

\PhpOffice\PhpSpreadsheet\Worksheet\Worksheet $pSheet
int $pSheetId

Returns

mixed —

writeDefinedNameForPrintArea()

writeDefinedNameForPrintArea(\PhpOffice\PhpSpreadsheet\Shared\XMLWriter  $objWriter, \PhpOffice\PhpSpreadsheet\Worksheet\Worksheet  $pSheet, int  $pSheetId) : mixed

Write Defined Name for PrintTitles.

Parameters

\PhpOffice\PhpSpreadsheet\Shared\XMLWriter $objWriter

XML Writer

\PhpOffice\PhpSpreadsheet\Worksheet\Worksheet $pSheet
int $pSheetId

Returns

mixed —