Properties

Methods

writeStyles()

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

Write styles to XML format.

Parameters

\PhpOffice\PhpSpreadsheet\Spreadsheet $spreadsheet

Throws

\PhpOffice\PhpSpreadsheet\Writer\Exception

Returns

string —

XML Output

allStyles()

allStyles(\PhpOffice\PhpSpreadsheet\Spreadsheet  $spreadsheet) : array<mixed,\PhpOffice\PhpSpreadsheet\Style\Style>

Get an array of all styles.

Parameters

\PhpOffice\PhpSpreadsheet\Spreadsheet $spreadsheet

Returns

array<mixed,\PhpOffice\PhpSpreadsheet\Style\Style> —

All styles in PhpSpreadsheet

allNumberFormats()

allNumberFormats(\PhpOffice\PhpSpreadsheet\Spreadsheet  $spreadsheet) : array<mixed,\PhpOffice\PhpSpreadsheet\Style\NumberFormat>

Get an array of all number formats.

Parameters

\PhpOffice\PhpSpreadsheet\Spreadsheet $spreadsheet

Returns

array<mixed,\PhpOffice\PhpSpreadsheet\Style\NumberFormat> —

All number formats in PhpSpreadsheet

writeCellStyleXf()

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

Write Cell Style Xf.

Parameters

\PhpOffice\PhpSpreadsheet\Shared\XMLWriter $objWriter

XML Writer

\PhpOffice\PhpSpreadsheet\Style\Style $pStyle

Style

\PhpOffice\PhpSpreadsheet\Spreadsheet $spreadsheet

Workbook

Throws

\PhpOffice\PhpSpreadsheet\Writer\Exception

writeCellStyleDxf()

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

Write Cell Style Dxf.

Parameters

\PhpOffice\PhpSpreadsheet\Shared\XMLWriter $objWriter

XML Writer

\PhpOffice\PhpSpreadsheet\Style\Style $pStyle

Style

writeNumFmt()

writeNumFmt(\PhpOffice\PhpSpreadsheet\Shared\XMLWriter  $objWriter, \PhpOffice\PhpSpreadsheet\Style\NumberFormat  $pNumberFormat, integer  $pId) 

Write NumberFormat.

Parameters

\PhpOffice\PhpSpreadsheet\Shared\XMLWriter $objWriter

XML Writer

\PhpOffice\PhpSpreadsheet\Style\NumberFormat $pNumberFormat

Number Format

integer $pId

Number Format identifier