PHPExcel_Writer_Excel2007_Worksheet

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

 Methods

Set parent IWriter object

__construct(\PHPExcel_Writer_IWriter $pWriter) 
Inherited
inherited_from \PHPExcel_Writer_Excel2007_WriterPart::__construct()

Parameters

Exceptions

\PHPExcel_Writer_Exception

Get parent IWriter object

getParentWriter() : \PHPExcel_Writer_IWriter
Inherited
inherited_from \PHPExcel_Writer_Excel2007_WriterPart::getParentWriter()

Exceptions

\PHPExcel_Writer_Exception

Returns

Set parent IWriter object

setParentWriter(\PHPExcel_Writer_IWriter $pWriter) 
Inherited
inherited_from \PHPExcel_Writer_Excel2007_WriterPart::setParentWriter()

Parameters

Exceptions

\PHPExcel_Writer_Exception

Write worksheet to XML format

writeWorksheet(\PHPExcel_Worksheet $pSheet, string[] $pStringTable, boolean $includeCharts) : string

Parameters

$pStringTable

string[]

$includeCharts

boolean

Flag indicating if we should write charts

Exceptions

\PHPExcel_Writer_Exception

Returns

stringXML Output

Write AutoFilter

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

Parameters

$objWriter

\PHPExcel_Shared_XMLWriter

XML Writer

$pSheet

\PHPExcel_Worksheet

Worksheet

Exceptions

\PHPExcel_Writer_Exception

Write Breaks

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

Parameters

$objWriter

\PHPExcel_Shared_XMLWriter

XML Writer

$pSheet

\PHPExcel_Worksheet

Worksheet

Exceptions

\PHPExcel_Writer_Exception

Write Cell

_writeCell(\PHPExcel_Shared_XMLWriter $objWriter, \PHPExcel_Worksheet $pSheet, \PHPExcel_Cell $pCellAddress, string[] $pStringTable, string[] $pFlippedStringTable) 

Parameters

$objWriter

\PHPExcel_Shared_XMLWriter

XML Writer

$pSheet

\PHPExcel_Worksheet

Worksheet

$pCellAddress

\PHPExcel_Cell

Cell Address

$pStringTable

string[]

String table

$pFlippedStringTable

string[]

String table (flipped), for faster index searching

Exceptions

\PHPExcel_Writer_Exception

Write Cols

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

Parameters

$objWriter

\PHPExcel_Shared_XMLWriter

XML Writer

$pSheet

\PHPExcel_Worksheet

Worksheet

Exceptions

\PHPExcel_Writer_Exception

Write ConditionalFormatting

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

Parameters

$objWriter

\PHPExcel_Shared_XMLWriter

XML Writer

$pSheet

\PHPExcel_Worksheet

Worksheet

Exceptions

\PHPExcel_Writer_Exception

Write DataValidations

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

Parameters

$objWriter

\PHPExcel_Shared_XMLWriter

XML Writer

$pSheet

\PHPExcel_Worksheet

Worksheet

Exceptions

\PHPExcel_Writer_Exception

Write Dimension

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

Parameters

$objWriter

\PHPExcel_Shared_XMLWriter

XML Writer

$pSheet

\PHPExcel_Worksheet

Worksheet

Exceptions

\PHPExcel_Writer_Exception

Write Drawings

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

Parameters

$objWriter

\PHPExcel_Shared_XMLWriter

XML Writer

$pSheet

\PHPExcel_Worksheet

Worksheet

$includeCharts

boolean

Flag indicating if we should include drawing details for charts

Exceptions

\PHPExcel_Writer_Exception

Write Header / Footer

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

Parameters

$objWriter

\PHPExcel_Shared_XMLWriter

XML Writer

$pSheet

\PHPExcel_Worksheet

Worksheet

Exceptions

\PHPExcel_Writer_Exception

Write LegacyDrawing

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

Parameters

$objWriter

\PHPExcel_Shared_XMLWriter

XML Writer

$pSheet

\PHPExcel_Worksheet

Worksheet

Exceptions

\PHPExcel_Writer_Exception

Write LegacyDrawingHF

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

Parameters

$objWriter

\PHPExcel_Shared_XMLWriter

XML Writer

$pSheet

\PHPExcel_Worksheet

Worksheet

Exceptions

\PHPExcel_Writer_Exception

Write MergeCells

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

Parameters

$objWriter

\PHPExcel_Shared_XMLWriter

XML Writer

$pSheet

\PHPExcel_Worksheet

Worksheet

Exceptions

\PHPExcel_Writer_Exception

Write PageMargins

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

Parameters

$objWriter

\PHPExcel_Shared_XMLWriter

XML Writer

$pSheet

\PHPExcel_Worksheet

Worksheet

Exceptions

\PHPExcel_Writer_Exception

Write PageSetup

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

Parameters

$objWriter

\PHPExcel_Shared_XMLWriter

XML Writer

$pSheet

\PHPExcel_Worksheet

Worksheet

Exceptions

\PHPExcel_Writer_Exception

Write PrintOptions

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

Parameters

$objWriter

\PHPExcel_Shared_XMLWriter

XML Writer

$pSheet

\PHPExcel_Worksheet

Worksheet

Exceptions

\PHPExcel_Writer_Exception

Write ProtectedRanges

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

Parameters

$objWriter

\PHPExcel_Shared_XMLWriter

XML Writer

$pSheet

\PHPExcel_Worksheet

Worksheet

Exceptions

\PHPExcel_Writer_Exception

Write SheetData

_writeSheetData(\PHPExcel_Shared_XMLWriter $objWriter, \PHPExcel_Worksheet $pSheet, string[] $pStringTable) 

Parameters

$objWriter

\PHPExcel_Shared_XMLWriter

XML Writer

$pSheet

\PHPExcel_Worksheet

Worksheet

$pStringTable

string[]

String table

Exceptions

\PHPExcel_Writer_Exception

Write SheetFormatPr

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

Parameters

$objWriter

\PHPExcel_Shared_XMLWriter

XML Writer

$pSheet

\PHPExcel_Worksheet

Worksheet

Exceptions

\PHPExcel_Writer_Exception

Write SheetPr

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

Parameters

$objWriter

\PHPExcel_Shared_XMLWriter

XML Writer

$pSheet

\PHPExcel_Worksheet

Worksheet

Exceptions

\PHPExcel_Writer_Exception

Write SheetProtection

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

Parameters

$objWriter

\PHPExcel_Shared_XMLWriter

XML Writer

$pSheet

\PHPExcel_Worksheet

Worksheet

Exceptions

\PHPExcel_Writer_Exception

Write SheetViews

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

Parameters

$objWriter

\PHPExcel_Shared_XMLWriter

XML Writer

$pSheet

\PHPExcel_Worksheet

Worksheet

Exceptions

\PHPExcel_Writer_Exception

 Properties

 

$_parentWriter : \PHPExcel_Writer_IWriter
Inherited
inherited_from \PHPExcel_Writer_Excel2007_WriterPart::$$_parentWriter