\PhpOffice\PhpSpreadsheet\Writer\XlsxStyle

Summary

Methods

Properties

Constants

getParentWriter()
__construct()
writeStyles()
allStyles()
allConditionalStyles()
allFills()
allFonts()
allBorders()
allNumberFormats()

No public properties found

No constants found

No protected methods found

No protected properties found

N/A

writeFill()
writeGradientFill()
writePatternFill()
writeFont()
writeBorder()
writeCellStyleXf()
writeCellStyleDxf()
writeBorderPr()
writeNumFmt()

$parentWriter

N/A

Properties

$parentWriter

$parentWriter : \PhpOffice\PhpSpreadsheet\Writer\Xlsx

Parent Xlsx object.

Type

\PhpOffice\PhpSpreadsheet\Writer\Xlsx

Methods

getParentWriter()

getParentWriter() : \PhpOffice\PhpSpreadsheet\Writer\Xlsx

Get parent Xlsx object.

Returns

\PhpOffice\PhpSpreadsheet\Writer\Xlsx

__construct()

__construct(\PhpOffice\PhpSpreadsheet\Writer\Xlsx  $pWriter)

Set parent Xlsx object.

Parameters

\PhpOffice\PhpSpreadsheet\Writer\Xlsx

$pWriter

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) : 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

allConditionalStyles()

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

Get an array of all conditional styles.

Parameters

\PhpOffice\PhpSpreadsheet\Spreadsheet

$spreadsheet

Returns

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

All conditional styles in PhpSpreadsheet

allFills()

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

Get an array of all fills.

Parameters

\PhpOffice\PhpSpreadsheet\Spreadsheet

$spreadsheet

Returns

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

All fills in PhpSpreadsheet

allFonts()

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

Get an array of all fonts.

Parameters

\PhpOffice\PhpSpreadsheet\Spreadsheet

$spreadsheet

Returns

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

All fonts in PhpSpreadsheet

allBorders()

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

Get an array of all borders.

Parameters

\PhpOffice\PhpSpreadsheet\Spreadsheet

$spreadsheet

Returns

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

All borders 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

writeFill()

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

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)

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)

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)

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)

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)

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)

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)

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, integer  $pId)

Write NumberFormat.

Parameters

\PhpOffice\PhpSpreadsheet\Shared\XMLWriter	$objWriter	XML Writer
\PhpOffice\PhpSpreadsheet\Style\NumberFormat	$pNumberFormat	Number Format
integer	$pId	Number Format identifier