Properties

Methods

setParentWriter()

setParentWriter(\PHPExcel_Writer_IWriter  $pWriter = null) 

Set parent IWriter object

Parameters

\PHPExcel_Writer_IWriter $pWriter

Throws

\PHPExcel_Writer_Exception

getParentWriter()

getParentWriter() : \PHPExcel_Writer_IWriter

Get parent IWriter object

Throws

\PHPExcel_Writer_Exception

Returns

\PHPExcel_Writer_IWriter

__construct()

__construct(\PHPExcel_Writer_IWriter  $pWriter = null) 

Set parent IWriter object

Parameters

\PHPExcel_Writer_IWriter $pWriter

Throws

\PHPExcel_Writer_Exception

writeWorksheet()

writeWorksheet(\PHPExcel_Worksheet  $pSheet = null, array<mixed,string>  $pStringTable = null, boolean  $includeCharts = FALSE) : string

Write worksheet to XML format

Parameters

\PHPExcel_Worksheet $pSheet
array<mixed,string> $pStringTable
boolean $includeCharts

Flag indicating if we should write charts

Throws

\PHPExcel_Writer_Exception

Returns

string —

XML Output

_writeSheetPr()

_writeSheetPr(\PHPExcel_Shared_XMLWriter  $objWriter = null, \PHPExcel_Worksheet  $pSheet = null) 

Write SheetPr

Parameters

\PHPExcel_Shared_XMLWriter $objWriter

XML Writer

\PHPExcel_Worksheet $pSheet

Worksheet

Throws

\PHPExcel_Writer_Exception

_writeDimension()

_writeDimension(\PHPExcel_Shared_XMLWriter  $objWriter = null, \PHPExcel_Worksheet  $pSheet = null) 

Write Dimension

Parameters

\PHPExcel_Shared_XMLWriter $objWriter

XML Writer

\PHPExcel_Worksheet $pSheet

Worksheet

Throws

\PHPExcel_Writer_Exception

_writeSheetViews()

_writeSheetViews(\PHPExcel_Shared_XMLWriter  $objWriter = NULL, \PHPExcel_Worksheet  $pSheet = NULL) 

Write SheetViews

Parameters

\PHPExcel_Shared_XMLWriter $objWriter

XML Writer

\PHPExcel_Worksheet $pSheet

Worksheet

Throws

\PHPExcel_Writer_Exception

_writeSheetFormatPr()

_writeSheetFormatPr(\PHPExcel_Shared_XMLWriter  $objWriter = null, \PHPExcel_Worksheet  $pSheet = null) 

Write SheetFormatPr

Parameters

\PHPExcel_Shared_XMLWriter $objWriter

XML Writer

\PHPExcel_Worksheet $pSheet

Worksheet

Throws

\PHPExcel_Writer_Exception

_writeCols()

_writeCols(\PHPExcel_Shared_XMLWriter  $objWriter = null, \PHPExcel_Worksheet  $pSheet = null) 

Write Cols

Parameters

\PHPExcel_Shared_XMLWriter $objWriter

XML Writer

\PHPExcel_Worksheet $pSheet

Worksheet

Throws

\PHPExcel_Writer_Exception

_writeSheetProtection()

_writeSheetProtection(\PHPExcel_Shared_XMLWriter  $objWriter = null, \PHPExcel_Worksheet  $pSheet = null) 

Write SheetProtection

Parameters

\PHPExcel_Shared_XMLWriter $objWriter

XML Writer

\PHPExcel_Worksheet $pSheet

Worksheet

Throws

\PHPExcel_Writer_Exception

_writeConditionalFormatting()

_writeConditionalFormatting(\PHPExcel_Shared_XMLWriter  $objWriter = null, \PHPExcel_Worksheet  $pSheet = null) 

Write ConditionalFormatting

Parameters

\PHPExcel_Shared_XMLWriter $objWriter

XML Writer

\PHPExcel_Worksheet $pSheet

Worksheet

Throws

\PHPExcel_Writer_Exception

_writeDataValidations()

_writeDataValidations(\PHPExcel_Shared_XMLWriter  $objWriter = null, \PHPExcel_Worksheet  $pSheet = null) 

Write DataValidations

Parameters

\PHPExcel_Shared_XMLWriter $objWriter

XML Writer

\PHPExcel_Worksheet $pSheet

Worksheet

Throws

\PHPExcel_Writer_Exception

_writeHyperlinks()

_writeHyperlinks(\PHPExcel_Shared_XMLWriter  $objWriter = null, \PHPExcel_Worksheet  $pSheet = null) 

Write Hyperlinks

Parameters

\PHPExcel_Shared_XMLWriter $objWriter

XML Writer

\PHPExcel_Worksheet $pSheet

Worksheet

Throws

\PHPExcel_Writer_Exception

_writeProtectedRanges()

_writeProtectedRanges(\PHPExcel_Shared_XMLWriter  $objWriter = null, \PHPExcel_Worksheet  $pSheet = null) 

Write ProtectedRanges

Parameters

\PHPExcel_Shared_XMLWriter $objWriter

XML Writer

\PHPExcel_Worksheet $pSheet

Worksheet

Throws

\PHPExcel_Writer_Exception

_writeMergeCells()

_writeMergeCells(\PHPExcel_Shared_XMLWriter  $objWriter = null, \PHPExcel_Worksheet  $pSheet = null) 

Write MergeCells

Parameters

\PHPExcel_Shared_XMLWriter $objWriter

XML Writer

\PHPExcel_Worksheet $pSheet

Worksheet

Throws

\PHPExcel_Writer_Exception

_writePrintOptions()

_writePrintOptions(\PHPExcel_Shared_XMLWriter  $objWriter = null, \PHPExcel_Worksheet  $pSheet = null) 

Write PrintOptions

Parameters

\PHPExcel_Shared_XMLWriter $objWriter

XML Writer

\PHPExcel_Worksheet $pSheet

Worksheet

Throws

\PHPExcel_Writer_Exception

_writePageMargins()

_writePageMargins(\PHPExcel_Shared_XMLWriter  $objWriter = null, \PHPExcel_Worksheet  $pSheet = null) 

Write PageMargins

Parameters

\PHPExcel_Shared_XMLWriter $objWriter

XML Writer

\PHPExcel_Worksheet $pSheet

Worksheet

Throws

\PHPExcel_Writer_Exception

_writeAutoFilter()

_writeAutoFilter(\PHPExcel_Shared_XMLWriter  $objWriter = null, \PHPExcel_Worksheet  $pSheet = null) 

Write AutoFilter

Parameters

\PHPExcel_Shared_XMLWriter $objWriter

XML Writer

\PHPExcel_Worksheet $pSheet

Worksheet

Throws

\PHPExcel_Writer_Exception

_writePageSetup()

_writePageSetup(\PHPExcel_Shared_XMLWriter  $objWriter = null, \PHPExcel_Worksheet  $pSheet = null) 

Write PageSetup

Parameters

\PHPExcel_Shared_XMLWriter $objWriter

XML Writer

\PHPExcel_Worksheet $pSheet

Worksheet

Throws

\PHPExcel_Writer_Exception

_writeHeaderFooter()

_writeHeaderFooter(\PHPExcel_Shared_XMLWriter  $objWriter = null, \PHPExcel_Worksheet  $pSheet = null) 

Write Header / Footer

Parameters

\PHPExcel_Shared_XMLWriter $objWriter

XML Writer

\PHPExcel_Worksheet $pSheet

Worksheet

Throws

\PHPExcel_Writer_Exception

_writeBreaks()

_writeBreaks(\PHPExcel_Shared_XMLWriter  $objWriter = null, \PHPExcel_Worksheet  $pSheet = null) 

Write Breaks

Parameters

\PHPExcel_Shared_XMLWriter $objWriter

XML Writer

\PHPExcel_Worksheet $pSheet

Worksheet

Throws

\PHPExcel_Writer_Exception

_writeSheetData()

_writeSheetData(\PHPExcel_Shared_XMLWriter  $objWriter = null, \PHPExcel_Worksheet  $pSheet = null, array<mixed,string>  $pStringTable = null) 

Write SheetData

Parameters

\PHPExcel_Shared_XMLWriter $objWriter

XML Writer

\PHPExcel_Worksheet $pSheet

Worksheet

array<mixed,string> $pStringTable

String table

Throws

\PHPExcel_Writer_Exception

_writeCell()

_writeCell(\PHPExcel_Shared_XMLWriter  $objWriter = null, \PHPExcel_Worksheet  $pSheet = null, \PHPExcel_Cell  $pCellAddress = null, array<mixed,string>  $pStringTable = null, array<mixed,string>  $pFlippedStringTable = null) 

Write Cell

Parameters

\PHPExcel_Shared_XMLWriter $objWriter

XML Writer

\PHPExcel_Worksheet $pSheet

Worksheet

\PHPExcel_Cell $pCellAddress

Cell Address

array<mixed,string> $pStringTable

String table

array<mixed,string> $pFlippedStringTable

String table (flipped), for faster index searching

Throws

\PHPExcel_Writer_Exception

_writeDrawings()

_writeDrawings(\PHPExcel_Shared_XMLWriter  $objWriter = null, \PHPExcel_Worksheet  $pSheet = null, boolean  $includeCharts = FALSE) 

Write Drawings

Parameters

\PHPExcel_Shared_XMLWriter $objWriter

XML Writer

\PHPExcel_Worksheet $pSheet

Worksheet

boolean $includeCharts

Flag indicating if we should include drawing details for charts

Throws

\PHPExcel_Writer_Exception

_writeLegacyDrawing()

_writeLegacyDrawing(\PHPExcel_Shared_XMLWriter  $objWriter = null, \PHPExcel_Worksheet  $pSheet = null) 

Write LegacyDrawing

Parameters

\PHPExcel_Shared_XMLWriter $objWriter

XML Writer

\PHPExcel_Worksheet $pSheet

Worksheet

Throws

\PHPExcel_Writer_Exception

_writeLegacyDrawingHF()

_writeLegacyDrawingHF(\PHPExcel_Shared_XMLWriter  $objWriter = null, \PHPExcel_Worksheet  $pSheet = null) 

Write LegacyDrawingHF

Parameters

\PHPExcel_Shared_XMLWriter $objWriter

XML Writer

\PHPExcel_Worksheet $pSheet

Worksheet

Throws

\PHPExcel_Writer_Exception