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 —

writeWorksheet()

writeWorksheet(\PhpOffice\PhpSpreadsheet\Worksheet\Worksheet  $pSheet, string[]  $pStringTable = null, bool  $includeCharts = false) : string

Write worksheet to XML format.

Parameters

\PhpOffice\PhpSpreadsheet\Worksheet\Worksheet $pSheet
string[] $pStringTable
bool $includeCharts

Flag indicating if we should write charts

Throws

\PhpOffice\PhpSpreadsheet\Writer\Exception

Returns

string —

XML Output

writeSheetPr()

writeSheetPr(\PhpOffice\PhpSpreadsheet\Shared\XMLWriter  $objWriter, \PhpOffice\PhpSpreadsheet\Worksheet\Worksheet  $pSheet) : mixed

Write SheetPr.

Parameters

\PhpOffice\PhpSpreadsheet\Shared\XMLWriter $objWriter

XML Writer

\PhpOffice\PhpSpreadsheet\Worksheet\Worksheet $pSheet

Worksheet

Returns

mixed —

writeDimension()

writeDimension(\PhpOffice\PhpSpreadsheet\Shared\XMLWriter  $objWriter, \PhpOffice\PhpSpreadsheet\Worksheet\Worksheet  $pSheet) : mixed

Write Dimension.

Parameters

\PhpOffice\PhpSpreadsheet\Shared\XMLWriter $objWriter

XML Writer

\PhpOffice\PhpSpreadsheet\Worksheet\Worksheet $pSheet

Worksheet

Returns

mixed —

writeSheetViews()

writeSheetViews(\PhpOffice\PhpSpreadsheet\Shared\XMLWriter  $objWriter, \PhpOffice\PhpSpreadsheet\Worksheet\Worksheet  $pSheet) : mixed

Write SheetViews.

Parameters

\PhpOffice\PhpSpreadsheet\Shared\XMLWriter $objWriter

XML Writer

\PhpOffice\PhpSpreadsheet\Worksheet\Worksheet $pSheet

Worksheet

Throws

\PhpOffice\PhpSpreadsheet\Writer\Exception

Returns

mixed —

writeSheetFormatPr()

writeSheetFormatPr(\PhpOffice\PhpSpreadsheet\Shared\XMLWriter  $objWriter, \PhpOffice\PhpSpreadsheet\Worksheet\Worksheet  $pSheet) : mixed

Write SheetFormatPr.

Parameters

\PhpOffice\PhpSpreadsheet\Shared\XMLWriter $objWriter

XML Writer

\PhpOffice\PhpSpreadsheet\Worksheet\Worksheet $pSheet

Worksheet

Returns

mixed —

writeCols()

writeCols(\PhpOffice\PhpSpreadsheet\Shared\XMLWriter  $objWriter, \PhpOffice\PhpSpreadsheet\Worksheet\Worksheet  $pSheet) : mixed

Write Cols.

Parameters

\PhpOffice\PhpSpreadsheet\Shared\XMLWriter $objWriter

XML Writer

\PhpOffice\PhpSpreadsheet\Worksheet\Worksheet $pSheet

Worksheet

Returns

mixed —

writeSheetProtection()

writeSheetProtection(\PhpOffice\PhpSpreadsheet\Shared\XMLWriter  $objWriter, \PhpOffice\PhpSpreadsheet\Worksheet\Worksheet  $pSheet) : mixed

Write SheetProtection.

Parameters

\PhpOffice\PhpSpreadsheet\Shared\XMLWriter $objWriter

XML Writer

\PhpOffice\PhpSpreadsheet\Worksheet\Worksheet $pSheet

Worksheet

Returns

mixed —

writeConditionalFormatting()

writeConditionalFormatting(\PhpOffice\PhpSpreadsheet\Shared\XMLWriter  $objWriter, \PhpOffice\PhpSpreadsheet\Worksheet\Worksheet  $pSheet) : mixed

Write ConditionalFormatting.

Parameters

\PhpOffice\PhpSpreadsheet\Shared\XMLWriter $objWriter

XML Writer

\PhpOffice\PhpSpreadsheet\Worksheet\Worksheet $pSheet

Worksheet

Throws

\PhpOffice\PhpSpreadsheet\Writer\Exception

Returns

mixed —

writeDataValidations()

writeDataValidations(\PhpOffice\PhpSpreadsheet\Shared\XMLWriter  $objWriter, \PhpOffice\PhpSpreadsheet\Worksheet\Worksheet  $pSheet) : mixed

Write DataValidations.

Parameters

\PhpOffice\PhpSpreadsheet\Shared\XMLWriter $objWriter

XML Writer

\PhpOffice\PhpSpreadsheet\Worksheet\Worksheet $pSheet

Worksheet

Returns

mixed —

writeHyperlinks()

writeHyperlinks(\PhpOffice\PhpSpreadsheet\Shared\XMLWriter  $objWriter, \PhpOffice\PhpSpreadsheet\Worksheet\Worksheet  $pSheet) : mixed

Write Hyperlinks.

Parameters

\PhpOffice\PhpSpreadsheet\Shared\XMLWriter $objWriter

XML Writer

\PhpOffice\PhpSpreadsheet\Worksheet\Worksheet $pSheet

Worksheet

Returns

mixed —

writeProtectedRanges()

writeProtectedRanges(\PhpOffice\PhpSpreadsheet\Shared\XMLWriter  $objWriter, \PhpOffice\PhpSpreadsheet\Worksheet\Worksheet  $pSheet) : mixed

Write ProtectedRanges.

Parameters

\PhpOffice\PhpSpreadsheet\Shared\XMLWriter $objWriter

XML Writer

\PhpOffice\PhpSpreadsheet\Worksheet\Worksheet $pSheet

Worksheet

Returns

mixed —

writeMergeCells()

writeMergeCells(\PhpOffice\PhpSpreadsheet\Shared\XMLWriter  $objWriter, \PhpOffice\PhpSpreadsheet\Worksheet\Worksheet  $pSheet) : mixed

Write MergeCells.

Parameters

\PhpOffice\PhpSpreadsheet\Shared\XMLWriter $objWriter

XML Writer

\PhpOffice\PhpSpreadsheet\Worksheet\Worksheet $pSheet

Worksheet

Returns

mixed —

writePrintOptions()

writePrintOptions(\PhpOffice\PhpSpreadsheet\Shared\XMLWriter  $objWriter, \PhpOffice\PhpSpreadsheet\Worksheet\Worksheet  $pSheet) : mixed

Write PrintOptions.

Parameters

\PhpOffice\PhpSpreadsheet\Shared\XMLWriter $objWriter

XML Writer

\PhpOffice\PhpSpreadsheet\Worksheet\Worksheet $pSheet

Worksheet

Returns

mixed —

writePageMargins()

writePageMargins(\PhpOffice\PhpSpreadsheet\Shared\XMLWriter  $objWriter, \PhpOffice\PhpSpreadsheet\Worksheet\Worksheet  $pSheet) : mixed

Write PageMargins.

Parameters

\PhpOffice\PhpSpreadsheet\Shared\XMLWriter $objWriter

XML Writer

\PhpOffice\PhpSpreadsheet\Worksheet\Worksheet $pSheet

Worksheet

Returns

mixed —

writeAutoFilter()

writeAutoFilter(\PhpOffice\PhpSpreadsheet\Shared\XMLWriter  $objWriter, \PhpOffice\PhpSpreadsheet\Worksheet\Worksheet  $pSheet) : mixed

Write AutoFilter.

Parameters

\PhpOffice\PhpSpreadsheet\Shared\XMLWriter $objWriter

XML Writer

\PhpOffice\PhpSpreadsheet\Worksheet\Worksheet $pSheet

Worksheet

Returns

mixed —

writePageSetup()

writePageSetup(\PhpOffice\PhpSpreadsheet\Shared\XMLWriter  $objWriter, \PhpOffice\PhpSpreadsheet\Worksheet\Worksheet  $pSheet) : mixed

Write PageSetup.

Parameters

\PhpOffice\PhpSpreadsheet\Shared\XMLWriter $objWriter

XML Writer

\PhpOffice\PhpSpreadsheet\Worksheet\Worksheet $pSheet

Worksheet

Returns

mixed —

writeHeaderFooter()

writeHeaderFooter(\PhpOffice\PhpSpreadsheet\Shared\XMLWriter  $objWriter, \PhpOffice\PhpSpreadsheet\Worksheet\Worksheet  $pSheet) : mixed

Write Header / Footer.

Parameters

\PhpOffice\PhpSpreadsheet\Shared\XMLWriter $objWriter

XML Writer

\PhpOffice\PhpSpreadsheet\Worksheet\Worksheet $pSheet

Worksheet

Returns

mixed —

writeBreaks()

writeBreaks(\PhpOffice\PhpSpreadsheet\Shared\XMLWriter  $objWriter, \PhpOffice\PhpSpreadsheet\Worksheet\Worksheet  $pSheet) : mixed

Write Breaks.

Parameters

\PhpOffice\PhpSpreadsheet\Shared\XMLWriter $objWriter

XML Writer

\PhpOffice\PhpSpreadsheet\Worksheet\Worksheet $pSheet

Worksheet

Returns

mixed —

writeSheetData()

writeSheetData(\PhpOffice\PhpSpreadsheet\Shared\XMLWriter  $objWriter, \PhpOffice\PhpSpreadsheet\Worksheet\Worksheet  $pSheet, string[]  $pStringTable) : mixed

Write SheetData.

Parameters

\PhpOffice\PhpSpreadsheet\Shared\XMLWriter $objWriter

XML Writer

\PhpOffice\PhpSpreadsheet\Worksheet\Worksheet $pSheet

Worksheet

string[] $pStringTable

String table

Throws

\PhpOffice\PhpSpreadsheet\Writer\Exception

Returns

mixed —

writeCell()

writeCell(\PhpOffice\PhpSpreadsheet\Shared\XMLWriter  $objWriter, \PhpOffice\PhpSpreadsheet\Worksheet\Worksheet  $pSheet, \PhpOffice\PhpSpreadsheet\Cell\Cell  $pCellAddress, string[]  $pFlippedStringTable) : mixed

Write Cell.

Parameters

\PhpOffice\PhpSpreadsheet\Shared\XMLWriter $objWriter

XML Writer

\PhpOffice\PhpSpreadsheet\Worksheet\Worksheet $pSheet

Worksheet

\PhpOffice\PhpSpreadsheet\Cell\Cell $pCellAddress

Cell Address

string[] $pFlippedStringTable

String table (flipped), for faster index searching

Throws

\PhpOffice\PhpSpreadsheet\Writer\Exception

Returns

mixed —

writeDrawings()

writeDrawings(\PhpOffice\PhpSpreadsheet\Shared\XMLWriter  $objWriter, \PhpOffice\PhpSpreadsheet\Worksheet\Worksheet  $pSheet, bool  $includeCharts = false) : mixed

Write Drawings.

Parameters

\PhpOffice\PhpSpreadsheet\Shared\XMLWriter $objWriter

XML Writer

\PhpOffice\PhpSpreadsheet\Worksheet\Worksheet $pSheet

Worksheet

bool $includeCharts

Flag indicating if we should include drawing details for charts

Returns

mixed —

writeLegacyDrawing()

writeLegacyDrawing(\PhpOffice\PhpSpreadsheet\Shared\XMLWriter  $objWriter, \PhpOffice\PhpSpreadsheet\Worksheet\Worksheet  $pSheet) : mixed

Write LegacyDrawing.

Parameters

\PhpOffice\PhpSpreadsheet\Shared\XMLWriter $objWriter

XML Writer

\PhpOffice\PhpSpreadsheet\Worksheet\Worksheet $pSheet

Worksheet

Returns

mixed —

writeLegacyDrawingHF()

writeLegacyDrawingHF(\PhpOffice\PhpSpreadsheet\Shared\XMLWriter  $objWriter, \PhpOffice\PhpSpreadsheet\Worksheet\Worksheet  $pSheet) : mixed

Write LegacyDrawingHF.

Parameters

\PhpOffice\PhpSpreadsheet\Shared\XMLWriter $objWriter

XML Writer

\PhpOffice\PhpSpreadsheet\Worksheet\Worksheet $pSheet

Worksheet

Returns

mixed —

writeAlternateContent()

writeAlternateContent(\PhpOffice\PhpSpreadsheet\Shared\XMLWriter  $objWriter, \PhpOffice\PhpSpreadsheet\Worksheet\Worksheet  $pSheet) : mixed

Parameters

\PhpOffice\PhpSpreadsheet\Shared\XMLWriter $objWriter
\PhpOffice\PhpSpreadsheet\Worksheet\Worksheet $pSheet

Returns

mixed —