\PHPExcel_Writer_Excel2007_Workbook

PHPExcel_Writer_Excel2007_Workbook

Copyright (c) 2006 - 2015 PHPExcel

This library is free software; you can redistribute it and/or modify it under the terms of the GNU Lesser General Public License as published by the Free Software Foundation; either version 2.1 of the License, or (at your option) any later version.

This library is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU Lesser General Public License for more details.

You should have received a copy of the GNU Lesser General Public License along with this library; if not, write to the Free Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA

Summary

Methods
Properties
Constants
setParentWriter()
getParentWriter()
__construct()
writeWorkbook()
No public properties found
No constants found
No protected methods found
No protected properties found
N/A
writeFileVersion()
writeWorkbookPr()
writeBookViews()
writeWorkbookProtection()
writeCalcPr()
writeSheets()
writeSheet()
writeDefinedNames()
writeNamedRanges()
writeDefinedNameForNamedRange()
writeDefinedNameForAutofilter()
writeDefinedNameForPrintTitles()
writeDefinedNameForPrintArea()
$parentWriter
N/A

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