\PhpOffice\PhpSpreadsheet\Writer\XlsxWorksheet

Summary

Methods

Properties

Constants

getParentWriter()
__construct()
writeWorksheet()

No public properties found

No constants found

No protected methods found

No protected properties found

N/A

writeSheetPr()
writeDimension()
writeSheetViews()
writeSheetFormatPr()
writeCols()
writeSheetProtection()
writeAttributeIf()
writeElementIf()
writeOtherCondElements()
writeTextCondElements()
writeExtConditionalFormattingElements()
writeDataBarElements()
writeConditionalFormatting()
writeDataValidations()
writeHyperlinks()
writeProtectedRanges()
writeMergeCells()
writePrintOptions()
writePageMargins()
writeAutoFilter()
writePageSetup()
writeHeaderFooter()
writeBreaks()
writeSheetData()
writeCellInlineStr()
writeCellString()
writeCellNumeric()
writeCellBoolean()
writeCellError()
writeCellFormula()
writeCell()
writeDrawings()
writeLegacyDrawing()
writeLegacyDrawingHF()
writeAlternateContent()
writeExtLst()

$parentWriter

N/A

File: serve/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Writer/Xlsx/Worksheet.php
Package: Application
Class hierarchy: WriterPart

\PhpOffice\PhpSpreadsheet\Writer\Xlsx\Worksheet
Uses

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

Returns

string —

XML Output

writeSheetPr()

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

Write SheetPr.

Parameters

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

writeDimension()

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

Write Dimension.

Parameters

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

writeSheetViews()

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

Write SheetViews.

Parameters

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

writeSheetFormatPr()

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

Write SheetFormatPr.

Parameters

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

writeCols()

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

Write Cols.

Parameters

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

writeSheetProtection()

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

Write SheetProtection.

Parameters

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

writeAttributeIf()

writeAttributeIf(\PhpOffice\PhpSpreadsheet\Shared\XMLWriter  $objWriter, mixed  $condition, string  $attr, string  $val) : void

Parameters

\PhpOffice\PhpSpreadsheet\Shared\XMLWriter	$objWriter
mixed	$condition
string	$attr
string	$val

writeElementIf()

writeElementIf(\PhpOffice\PhpSpreadsheet\Shared\XMLWriter  $objWriter, mixed  $condition, string  $attr, string  $val) : void

Parameters

\PhpOffice\PhpSpreadsheet\Shared\XMLWriter	$objWriter
mixed	$condition
string	$attr
string	$val

writeOtherCondElements()

writeOtherCondElements(\PhpOffice\PhpSpreadsheet\Shared\XMLWriter  $objWriter, \PhpOffice\PhpSpreadsheet\Style\Conditional  $conditional, string  $cellCoordinate) : void

Parameters

\PhpOffice\PhpSpreadsheet\Shared\XMLWriter	$objWriter
\PhpOffice\PhpSpreadsheet\Style\Conditional	$conditional
string	$cellCoordinate

writeTextCondElements()

writeTextCondElements(\PhpOffice\PhpSpreadsheet\Shared\XMLWriter  $objWriter, \PhpOffice\PhpSpreadsheet\Style\Conditional  $conditional, string  $cellCoordinate) : void

Parameters

\PhpOffice\PhpSpreadsheet\Shared\XMLWriter	$objWriter
\PhpOffice\PhpSpreadsheet\Style\Conditional	$conditional
string	$cellCoordinate

writeExtConditionalFormattingElements()

writeExtConditionalFormattingElements(\PhpOffice\PhpSpreadsheet\Shared\XMLWriter  $objWriter, \PhpOffice\PhpSpreadsheet\Style\ConditionalFormatting\ConditionalFormattingRuleExtension  $ruleExtension) : void

Parameters

\PhpOffice\PhpSpreadsheet\Shared\XMLWriter	$objWriter
\PhpOffice\PhpSpreadsheet\Style\ConditionalFormatting\ConditionalFormattingRuleExtension	$ruleExtension

writeDataBarElements()

writeDataBarElements(\PhpOffice\PhpSpreadsheet\Shared\XMLWriter  $objWriter, mixed  $dataBar) : void

Parameters

\PhpOffice\PhpSpreadsheet\Shared\XMLWriter	$objWriter
mixed	$dataBar

writeConditionalFormatting()

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

Write ConditionalFormatting.

Parameters

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

writeDataValidations()

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

Write DataValidations.

Parameters

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

writeHyperlinks()

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

Write Hyperlinks.

Parameters

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

writeProtectedRanges()

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

Write ProtectedRanges.

Parameters

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

writeMergeCells()

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

Write MergeCells.

Parameters

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

writePrintOptions()

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

Write PrintOptions.

Parameters

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

writePageMargins()

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

Write PageMargins.

Parameters

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

writeAutoFilter()

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

Write AutoFilter.

Parameters

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

writePageSetup()

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

Write PageSetup.

Parameters

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

writeHeaderFooter()

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

Write Header / Footer.

Parameters

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

writeBreaks()

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

Write Breaks.

Parameters

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

writeSheetData()

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

Write SheetData.

Parameters

\PhpOffice\PhpSpreadsheet\Shared\XMLWriter	$objWriter	XML Writer
\PhpOffice\PhpSpreadsheet\Worksheet\Worksheet	$pSheet	Worksheet
string[]	$pStringTable	String table

writeCellInlineStr()

writeCellInlineStr(\PhpOffice\PhpSpreadsheet\Shared\XMLWriter  $objWriter, string  $mappedType, \PhpOffice\PhpSpreadsheet\RichText\RichText|string  $cellValue) : void

Parameters

\PhpOffice\PhpSpreadsheet\Shared\XMLWriter	$objWriter
string	$mappedType
\PhpOffice\PhpSpreadsheet\RichText\RichText\|string	$cellValue

writeCellString()

writeCellString(\PhpOffice\PhpSpreadsheet\Shared\XMLWriter  $objWriter, string  $mappedType, \PhpOffice\PhpSpreadsheet\RichText\RichText|string  $cellValue, string[]  $pFlippedStringTable) : void

Parameters

\PhpOffice\PhpSpreadsheet\Shared\XMLWriter	$objWriter
string	$mappedType
\PhpOffice\PhpSpreadsheet\RichText\RichText\|string	$cellValue
string[]	$pFlippedStringTable

writeCellNumeric()

writeCellNumeric(\PhpOffice\PhpSpreadsheet\Shared\XMLWriter  $objWriter, float|int  $cellValue) : void

Parameters

\PhpOffice\PhpSpreadsheet\Shared\XMLWriter	$objWriter
float\|int	$cellValue

writeCellBoolean()

writeCellBoolean(\PhpOffice\PhpSpreadsheet\Shared\XMLWriter  $objWriter, string  $mappedType, bool  $cellValue) : void

Parameters

\PhpOffice\PhpSpreadsheet\Shared\XMLWriter	$objWriter
string	$mappedType
bool	$cellValue

writeCellError()

writeCellError(\PhpOffice\PhpSpreadsheet\Shared\XMLWriter  $objWriter, string  $mappedType, string  $cellValue, string  $formulaerr = '#NULL!') : void

Parameters

\PhpOffice\PhpSpreadsheet\Shared\XMLWriter	$objWriter
string	$mappedType
string	$cellValue
string	$formulaerr

writeCellFormula()

writeCellFormula(\PhpOffice\PhpSpreadsheet\Shared\XMLWriter  $objWriter, string  $cellValue, \PhpOffice\PhpSpreadsheet\Cell\Cell  $pCell) : void

Parameters

\PhpOffice\PhpSpreadsheet\Shared\XMLWriter	$objWriter
string	$cellValue
\PhpOffice\PhpSpreadsheet\Cell\Cell	$pCell

writeCell()

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

Write Cell.

Parameters

\PhpOffice\PhpSpreadsheet\Shared\XMLWriter	$objWriter	XML Writer
\PhpOffice\PhpSpreadsheet\Worksheet\Worksheet	$pSheet	Worksheet
string	$pCellAddress	Cell Address
string[]	$pFlippedStringTable	String table (flipped), for faster index searching

writeDrawings()

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

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

writeLegacyDrawing()

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

Write LegacyDrawing.

Parameters

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

writeLegacyDrawingHF()

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

Write LegacyDrawingHF.

Parameters

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

writeAlternateContent()

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

Parameters

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

writeExtLst()

writeExtLst(\PhpOffice\PhpSpreadsheet\Shared\XMLWriter  $objWriter, \PhpOffice\PhpSpreadsheet\Worksheet\Worksheet  $pSheet) : void

write <ExtLst> only implementation conditionalFormattings.

Parameters

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

Inherited from: \PhpOffice\PhpSpreadsheet\Writer\Xlsx\Worksheet
Uses