\PHPExcel_Writer_Excel2007_Workbook

PHPExcel_Writer_Excel2007_Workbook

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

File: core/class/PHPExcel/Writer/Excel2007/Workbook.php
Package: Writer\Excel2007
Class hierarchy: PHPExcel_Writer_Excel2007_WriterPart

\PHPExcel_Writer_Excel2007_Workbook
Uses

Properties

$_parentWriter

$_parentWriter : \PHPExcel_Writer_IWriter

Parent IWriter object

Type

PHPExcel_Writer_IWriter —

Methods

setParentWriter()

setParentWriter(\PHPExcel_Writer_IWriter  $pWriter = null) : mixed

Set parent IWriter object

Parameters

\PHPExcel_Writer_IWriter

$pWriter

Throws

\PHPExcel_Writer_Exception

Returns

mixed —

getParentWriter()

getParentWriter() : \PHPExcel_Writer_IWriter

Get parent IWriter object

Throws

\PHPExcel_Writer_Exception

Returns

\PHPExcel_Writer_IWriter —

__construct()

__construct(\PHPExcel_Writer_IWriter  $pWriter = null) : mixed

Set parent IWriter object

Parameters

\PHPExcel_Writer_IWriter

$pWriter

Throws

\PHPExcel_Writer_Exception

Returns

mixed —

writeWorkbook()

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

Write workbook to XML format

Parameters

\PHPExcel	$pPHPExcel
bool	$recalcRequired	Indicate whether formulas should be recalculated before writing

Throws

\PHPExcel_Writer_Exception

Returns

string —

XML Output

_writeFileVersion()

_writeFileVersion(\PHPExcel_Shared_XMLWriter  $objWriter = null) : mixed

Write file version

Parameters

\PHPExcel_Shared_XMLWriter

$objWriter

XML Writer

Throws

\PHPExcel_Writer_Exception

Returns

mixed —

_writeWorkbookPr()

_writeWorkbookPr(\PHPExcel_Shared_XMLWriter  $objWriter = null) : mixed

Write WorkbookPr

Parameters

\PHPExcel_Shared_XMLWriter

$objWriter

XML Writer

Throws

\PHPExcel_Writer_Exception

Returns

mixed —

_writeBookViews()

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

Write BookViews

Parameters

\PHPExcel_Shared_XMLWriter	$objWriter	XML Writer
\PHPExcel	$pPHPExcel

Throws

\PHPExcel_Writer_Exception

Returns

mixed —

_writeWorkbookProtection()

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

Write WorkbookProtection

Parameters

\PHPExcel_Shared_XMLWriter	$objWriter	XML Writer
\PHPExcel	$pPHPExcel

Throws

\PHPExcel_Writer_Exception

Returns

mixed —

_writeCalcPr()

_writeCalcPr(\PHPExcel_Shared_XMLWriter  $objWriter = null, bool  $recalcRequired = TRUE) : mixed

Write calcPr

Parameters

\PHPExcel_Shared_XMLWriter	$objWriter	XML Writer
bool	$recalcRequired	Indicate whether formulas should be recalculated before writing

Throws

\PHPExcel_Writer_Exception

Returns

mixed —

_writeSheets()

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

Write sheets

Parameters

\PHPExcel_Shared_XMLWriter	$objWriter	XML Writer
\PHPExcel	$pPHPExcel

Throws

\PHPExcel_Writer_Exception

Returns

mixed —

_writeSheet()

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

Write sheet

Parameters

\PHPExcel_Shared_XMLWriter	$objWriter	XML Writer
string	$pSheetname	Sheet name
int	$pSheetId	Sheet id
int	$pRelId	Relationship ID
string	$sheetState	Sheet state (visible, hidden, veryHidden)

Throws

\PHPExcel_Writer_Exception

Returns

mixed —

_writeDefinedNames()

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

Write Defined Names

Parameters

\PHPExcel_Shared_XMLWriter	$objWriter	XML Writer
\PHPExcel	$pPHPExcel

Throws

\PHPExcel_Writer_Exception

Returns

mixed —

_writeNamedRanges()

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

Write named ranges

Parameters

\PHPExcel_Shared_XMLWriter	$objWriter	XML Writer
\PHPExcel	$pPHPExcel

Throws

\PHPExcel_Writer_Exception

Returns

mixed —

_writeDefinedNameForNamedRange()

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

Write Defined Name for named range

Parameters

\PHPExcel_Shared_XMLWriter	$objWriter	XML Writer
\PHPExcel_NamedRange	$pNamedRange

Throws

\PHPExcel_Writer_Exception

Returns

mixed —

_writeDefinedNameForAutofilter()

_writeDefinedNameForAutofilter(\PHPExcel_Shared_XMLWriter  $objWriter = null, \PHPExcel_Worksheet  $pSheet = null, int  $pSheetId) : mixed

Write Defined Name for autoFilter

Parameters

\PHPExcel_Shared_XMLWriter	$objWriter	XML Writer
\PHPExcel_Worksheet	$pSheet
int	$pSheetId

Throws

\PHPExcel_Writer_Exception

Returns

mixed —

_writeDefinedNameForPrintTitles()

_writeDefinedNameForPrintTitles(\PHPExcel_Shared_XMLWriter  $objWriter = null, \PHPExcel_Worksheet  $pSheet = null, int  $pSheetId) : mixed

Write Defined Name for PrintTitles

Parameters

\PHPExcel_Shared_XMLWriter	$objWriter	XML Writer
\PHPExcel_Worksheet	$pSheet
int	$pSheetId

Throws

\PHPExcel_Writer_Exception

Returns

mixed —

_writeDefinedNameForPrintArea()

_writeDefinedNameForPrintArea(\PHPExcel_Shared_XMLWriter  $objWriter = null, \PHPExcel_Worksheet  $pSheet = null, int  $pSheetId) : mixed

Write Defined Name for PrintTitles

Parameters

\PHPExcel_Shared_XMLWriter	$objWriter	XML Writer
\PHPExcel_Worksheet	$pSheet
int	$pSheetId

Throws

\PHPExcel_Writer_Exception

Returns

mixed —

category	PHPExcel
copyright	Copyright (c) 2006 - 2014 PHPExcel (http://www.codeplex.com/PHPExcel)