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

writeWorkbook()

writeWorkbook(\PHPExcel  $pPHPExcel = null, boolean  $recalcRequired = FALSE) : string

Write workbook to XML format

Parameters

\PHPExcel $pPHPExcel
boolean $recalcRequired

Indicate whether formulas should be recalculated before writing

Throws

\PHPExcel_Writer_Exception

Returns

string —

XML Output

_writeFileVersion()

_writeFileVersion(\PHPExcel_Shared_XMLWriter  $objWriter = null) 

Write file version

Parameters

\PHPExcel_Shared_XMLWriter $objWriter

XML Writer

Throws

\PHPExcel_Writer_Exception

_writeWorkbookPr()

_writeWorkbookPr(\PHPExcel_Shared_XMLWriter  $objWriter = null) 

Write WorkbookPr

Parameters

\PHPExcel_Shared_XMLWriter $objWriter

XML Writer

Throws

\PHPExcel_Writer_Exception

_writeBookViews()

_writeBookViews(\PHPExcel_Shared_XMLWriter  $objWriter = null, \PHPExcel  $pPHPExcel = null) 

Write BookViews

Parameters

\PHPExcel_Shared_XMLWriter $objWriter

XML Writer

\PHPExcel $pPHPExcel

Throws

\PHPExcel_Writer_Exception

_writeWorkbookProtection()

_writeWorkbookProtection(\PHPExcel_Shared_XMLWriter  $objWriter = null, \PHPExcel  $pPHPExcel = null) 

Write WorkbookProtection

Parameters

\PHPExcel_Shared_XMLWriter $objWriter

XML Writer

\PHPExcel $pPHPExcel

Throws

\PHPExcel_Writer_Exception

_writeCalcPr()

_writeCalcPr(\PHPExcel_Shared_XMLWriter  $objWriter = null, boolean  $recalcRequired = TRUE) 

Write calcPr

Parameters

\PHPExcel_Shared_XMLWriter $objWriter

XML Writer

boolean $recalcRequired

Indicate whether formulas should be recalculated before writing

Throws

\PHPExcel_Writer_Exception

_writeSheets()

_writeSheets(\PHPExcel_Shared_XMLWriter  $objWriter = null, \PHPExcel  $pPHPExcel = null) 

Write sheets

Parameters

\PHPExcel_Shared_XMLWriter $objWriter

XML Writer

\PHPExcel $pPHPExcel

Throws

\PHPExcel_Writer_Exception

_writeSheet()

_writeSheet(\PHPExcel_Shared_XMLWriter  $objWriter = null, string  $pSheetname = '', integer  $pSheetId = 1, integer  $pRelId = 1, string  $sheetState = 'visible') 

Write sheet

Parameters

\PHPExcel_Shared_XMLWriter $objWriter

XML Writer

string $pSheetname

Sheet name

integer $pSheetId

Sheet id

integer $pRelId

Relationship ID

string $sheetState

Sheet state (visible, hidden, veryHidden)

Throws

\PHPExcel_Writer_Exception

_writeDefinedNames()

_writeDefinedNames(\PHPExcel_Shared_XMLWriter  $objWriter = null, \PHPExcel  $pPHPExcel = null) 

Write Defined Names

Parameters

\PHPExcel_Shared_XMLWriter $objWriter

XML Writer

\PHPExcel $pPHPExcel

Throws

\PHPExcel_Writer_Exception

_writeNamedRanges()

_writeNamedRanges(\PHPExcel_Shared_XMLWriter  $objWriter = null, \PHPExcel  $pPHPExcel) 

Write named ranges

Parameters

\PHPExcel_Shared_XMLWriter $objWriter

XML Writer

\PHPExcel $pPHPExcel

Throws

\PHPExcel_Writer_Exception

_writeDefinedNameForNamedRange()

_writeDefinedNameForNamedRange(\PHPExcel_Shared_XMLWriter  $objWriter = null, \PHPExcel_NamedRange  $pNamedRange) 

Write Defined Name for named range

Parameters

\PHPExcel_Shared_XMLWriter $objWriter

XML Writer

\PHPExcel_NamedRange $pNamedRange

Throws

\PHPExcel_Writer_Exception

_writeDefinedNameForAutofilter()

_writeDefinedNameForAutofilter(\PHPExcel_Shared_XMLWriter  $objWriter = null, \PHPExcel_Worksheet  $pSheet = null, integer  $pSheetId) 

Write Defined Name for autoFilter

Parameters

\PHPExcel_Shared_XMLWriter $objWriter

XML Writer

\PHPExcel_Worksheet $pSheet
integer $pSheetId

Throws

\PHPExcel_Writer_Exception

_writeDefinedNameForPrintTitles()

_writeDefinedNameForPrintTitles(\PHPExcel_Shared_XMLWriter  $objWriter = null, \PHPExcel_Worksheet  $pSheet = null, integer  $pSheetId) 

Write Defined Name for PrintTitles

Parameters

\PHPExcel_Shared_XMLWriter $objWriter

XML Writer

\PHPExcel_Worksheet $pSheet
integer $pSheetId

Throws

\PHPExcel_Writer_Exception

_writeDefinedNameForPrintArea()

_writeDefinedNameForPrintArea(\PHPExcel_Shared_XMLWriter  $objWriter = null, \PHPExcel_Worksheet  $pSheet = null, integer  $pSheetId) 

Write Defined Name for PrintTitles

Parameters

\PHPExcel_Shared_XMLWriter $objWriter

XML Writer

\PHPExcel_Worksheet $pSheet
integer $pSheetId

Throws

\PHPExcel_Writer_Exception