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 —

writeStyles()

writeStyles(\PhpOffice\PhpSpreadsheet\Spreadsheet  $spreadsheet) : string

Write styles to XML format.

Parameters

\PhpOffice\PhpSpreadsheet\Spreadsheet $spreadsheet

Returns

string —

XML Output

allStyles()

allStyles(\PhpOffice\PhpSpreadsheet\Spreadsheet  $spreadsheet) : \PhpOffice\PhpSpreadsheet\Style\Style[]

Get an array of all styles.

Parameters

\PhpOffice\PhpSpreadsheet\Spreadsheet $spreadsheet

Returns

\PhpOffice\PhpSpreadsheet\Style\Style[] —

All styles in PhpSpreadsheet

allConditionalStyles()

allConditionalStyles(\PhpOffice\PhpSpreadsheet\Spreadsheet  $spreadsheet) : \PhpOffice\PhpSpreadsheet\Style\Conditional[]

Get an array of all conditional styles.

Parameters

\PhpOffice\PhpSpreadsheet\Spreadsheet $spreadsheet

Returns

\PhpOffice\PhpSpreadsheet\Style\Conditional[] —

All conditional styles in PhpSpreadsheet

allFills()

allFills(\PhpOffice\PhpSpreadsheet\Spreadsheet  $spreadsheet) : \PhpOffice\PhpSpreadsheet\Style\Fill[]

Get an array of all fills.

Parameters

\PhpOffice\PhpSpreadsheet\Spreadsheet $spreadsheet

Returns

\PhpOffice\PhpSpreadsheet\Style\Fill[] —

All fills in PhpSpreadsheet

allFonts()

allFonts(\PhpOffice\PhpSpreadsheet\Spreadsheet  $spreadsheet) : \PhpOffice\PhpSpreadsheet\Style\Font[]

Get an array of all fonts.

Parameters

\PhpOffice\PhpSpreadsheet\Spreadsheet $spreadsheet

Returns

\PhpOffice\PhpSpreadsheet\Style\Font[] —

All fonts in PhpSpreadsheet

allBorders()

allBorders(\PhpOffice\PhpSpreadsheet\Spreadsheet  $spreadsheet) : \PhpOffice\PhpSpreadsheet\Style\Borders[]

Get an array of all borders.

Parameters

\PhpOffice\PhpSpreadsheet\Spreadsheet $spreadsheet

Returns

\PhpOffice\PhpSpreadsheet\Style\Borders[] —

All borders in PhpSpreadsheet

allNumberFormats()

allNumberFormats(\PhpOffice\PhpSpreadsheet\Spreadsheet  $spreadsheet) : \PhpOffice\PhpSpreadsheet\Style\NumberFormat[]

Get an array of all number formats.

Parameters

\PhpOffice\PhpSpreadsheet\Spreadsheet $spreadsheet

Returns

\PhpOffice\PhpSpreadsheet\Style\NumberFormat[] —

All number formats in PhpSpreadsheet

writeFill()

writeFill(\PhpOffice\PhpSpreadsheet\Shared\XMLWriter  $objWriter, \PhpOffice\PhpSpreadsheet\Style\Fill  $pFill) : void

Write Fill.

Parameters

\PhpOffice\PhpSpreadsheet\Shared\XMLWriter $objWriter

XML Writer

\PhpOffice\PhpSpreadsheet\Style\Fill $pFill

Fill style

writeGradientFill()

writeGradientFill(\PhpOffice\PhpSpreadsheet\Shared\XMLWriter  $objWriter, \PhpOffice\PhpSpreadsheet\Style\Fill  $pFill) : void

Write Gradient Fill.

Parameters

\PhpOffice\PhpSpreadsheet\Shared\XMLWriter $objWriter

XML Writer

\PhpOffice\PhpSpreadsheet\Style\Fill $pFill

Fill style

writePatternFill()

writePatternFill(\PhpOffice\PhpSpreadsheet\Shared\XMLWriter  $objWriter, \PhpOffice\PhpSpreadsheet\Style\Fill  $pFill) : void

Write Pattern Fill.

Parameters

\PhpOffice\PhpSpreadsheet\Shared\XMLWriter $objWriter

XML Writer

\PhpOffice\PhpSpreadsheet\Style\Fill $pFill

Fill style

writeFont()

writeFont(\PhpOffice\PhpSpreadsheet\Shared\XMLWriter  $objWriter, \PhpOffice\PhpSpreadsheet\Style\Font  $pFont) : void

Write Font.

Parameters

\PhpOffice\PhpSpreadsheet\Shared\XMLWriter $objWriter

XML Writer

\PhpOffice\PhpSpreadsheet\Style\Font $pFont

Font style

writeBorder()

writeBorder(\PhpOffice\PhpSpreadsheet\Shared\XMLWriter  $objWriter, \PhpOffice\PhpSpreadsheet\Style\Borders  $pBorders) : void

Write Border.

Parameters

\PhpOffice\PhpSpreadsheet\Shared\XMLWriter $objWriter

XML Writer

\PhpOffice\PhpSpreadsheet\Style\Borders $pBorders

Borders style

writeCellStyleXf()

writeCellStyleXf(\PhpOffice\PhpSpreadsheet\Shared\XMLWriter  $objWriter, \PhpOffice\PhpSpreadsheet\Style\Style  $pStyle, \PhpOffice\PhpSpreadsheet\Spreadsheet  $spreadsheet) : void

Write Cell Style Xf.

Parameters

\PhpOffice\PhpSpreadsheet\Shared\XMLWriter $objWriter

XML Writer

\PhpOffice\PhpSpreadsheet\Style\Style $pStyle

Style

\PhpOffice\PhpSpreadsheet\Spreadsheet $spreadsheet

Workbook

writeCellStyleDxf()

writeCellStyleDxf(\PhpOffice\PhpSpreadsheet\Shared\XMLWriter  $objWriter, \PhpOffice\PhpSpreadsheet\Style\Style  $pStyle) : void

Write Cell Style Dxf.

Parameters

\PhpOffice\PhpSpreadsheet\Shared\XMLWriter $objWriter

XML Writer

\PhpOffice\PhpSpreadsheet\Style\Style $pStyle

Style

writeBorderPr()

writeBorderPr(\PhpOffice\PhpSpreadsheet\Shared\XMLWriter  $objWriter, string  $pName, \PhpOffice\PhpSpreadsheet\Style\Border  $pBorder) : void

Write BorderPr.

Parameters

\PhpOffice\PhpSpreadsheet\Shared\XMLWriter $objWriter

XML Writer

string $pName

Element name

\PhpOffice\PhpSpreadsheet\Style\Border $pBorder

Border style

writeNumFmt()

writeNumFmt(\PhpOffice\PhpSpreadsheet\Shared\XMLWriter  $objWriter, \PhpOffice\PhpSpreadsheet\Style\NumberFormat  $pNumberFormat, int  $pId) : void

Write NumberFormat.

Parameters

\PhpOffice\PhpSpreadsheet\Shared\XMLWriter $objWriter

XML Writer

\PhpOffice\PhpSpreadsheet\Style\NumberFormat $pNumberFormat

Number Format

int $pId

Number Format identifier