\PHPExcel_Writer_Excel2007_Worksheet

PHPExcel_Writer_Excel2007_Worksheet

Summary

Methods

Properties

Constants

setParentWriter()
getParentWriter()
__construct()
writeWorksheet()

No public properties found

No constants found

No protected methods found

No protected properties found

N/A

_writeSheetPr()
_writeDimension()
_writeSheetViews()
_writeSheetFormatPr()
_writeCols()
_writeSheetProtection()
_writeConditionalFormatting()
_writeDataValidations()
_writeHyperlinks()
_writeProtectedRanges()
_writeMergeCells()
_writePrintOptions()
_writePageMargins()
_writeAutoFilter()
_writePageSetup()
_writeHeaderFooter()
_writeBreaks()
_writeSheetData()
_writeCell()
_writeDrawings()
_writeLegacyDrawing()
_writeLegacyDrawingHF()

$_parentWriter

N/A

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

\PHPExcel_Writer_Excel2007_Worksheet
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 —

writeWorksheet()

writeWorksheet(\PHPExcel_Worksheet  $pSheet = null, string[]  $pStringTable = null, bool  $includeCharts = FALSE) : string

Write worksheet to XML format

Parameters

\PHPExcel_Worksheet	$pSheet
string[]	$pStringTable
bool	$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) : mixed

Write SheetPr

Parameters

\PHPExcel_Shared_XMLWriter	$objWriter	XML Writer
\PHPExcel_Worksheet	$pSheet	Worksheet

Throws

\PHPExcel_Writer_Exception

Returns

mixed —

_writeDimension()

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

Write Dimension

Parameters

\PHPExcel_Shared_XMLWriter	$objWriter	XML Writer
\PHPExcel_Worksheet	$pSheet	Worksheet

Throws

\PHPExcel_Writer_Exception

Returns

mixed —

_writeSheetViews()

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

Write SheetViews

Parameters

\PHPExcel_Shared_XMLWriter	$objWriter	XML Writer
\PHPExcel_Worksheet	$pSheet	Worksheet

Throws

\PHPExcel_Writer_Exception

Returns

mixed —

_writeSheetFormatPr()

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

Write SheetFormatPr

Parameters

\PHPExcel_Shared_XMLWriter	$objWriter	XML Writer
\PHPExcel_Worksheet	$pSheet	Worksheet

Throws

\PHPExcel_Writer_Exception

Returns

mixed —

_writeCols()

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

Write Cols

Parameters

\PHPExcel_Shared_XMLWriter	$objWriter	XML Writer
\PHPExcel_Worksheet	$pSheet	Worksheet

Throws

\PHPExcel_Writer_Exception

Returns

mixed —

_writeSheetProtection()

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

Write SheetProtection

Parameters

\PHPExcel_Shared_XMLWriter	$objWriter	XML Writer
\PHPExcel_Worksheet	$pSheet	Worksheet

Throws

\PHPExcel_Writer_Exception

Returns

mixed —

_writeConditionalFormatting()

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

Write ConditionalFormatting

Parameters

\PHPExcel_Shared_XMLWriter	$objWriter	XML Writer
\PHPExcel_Worksheet	$pSheet	Worksheet

Throws

\PHPExcel_Writer_Exception

Returns

mixed —

_writeDataValidations()

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

Write DataValidations

Parameters

\PHPExcel_Shared_XMLWriter	$objWriter	XML Writer
\PHPExcel_Worksheet	$pSheet	Worksheet

Throws

\PHPExcel_Writer_Exception

Returns

mixed —

_writeHyperlinks()

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

Write Hyperlinks

Parameters

\PHPExcel_Shared_XMLWriter	$objWriter	XML Writer
\PHPExcel_Worksheet	$pSheet	Worksheet

Throws

\PHPExcel_Writer_Exception

Returns

mixed —

_writeProtectedRanges()

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

Write ProtectedRanges

Parameters

\PHPExcel_Shared_XMLWriter	$objWriter	XML Writer
\PHPExcel_Worksheet	$pSheet	Worksheet

Throws

\PHPExcel_Writer_Exception

Returns

mixed —

_writeMergeCells()

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

Write MergeCells

Parameters

\PHPExcel_Shared_XMLWriter	$objWriter	XML Writer
\PHPExcel_Worksheet	$pSheet	Worksheet

Throws

\PHPExcel_Writer_Exception

Returns

mixed —

_writePrintOptions()

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

Write PrintOptions

Parameters

\PHPExcel_Shared_XMLWriter	$objWriter	XML Writer
\PHPExcel_Worksheet	$pSheet	Worksheet

Throws

\PHPExcel_Writer_Exception

Returns

mixed —

_writePageMargins()

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

Write PageMargins

Parameters

\PHPExcel_Shared_XMLWriter	$objWriter	XML Writer
\PHPExcel_Worksheet	$pSheet	Worksheet

Throws

\PHPExcel_Writer_Exception

Returns

mixed —

_writeAutoFilter()

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

Write AutoFilter

Parameters

\PHPExcel_Shared_XMLWriter	$objWriter	XML Writer
\PHPExcel_Worksheet	$pSheet	Worksheet

Throws

\PHPExcel_Writer_Exception

Returns

mixed —

_writePageSetup()

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

Write PageSetup

Parameters

\PHPExcel_Shared_XMLWriter	$objWriter	XML Writer
\PHPExcel_Worksheet	$pSheet	Worksheet

Throws

\PHPExcel_Writer_Exception

Returns

mixed —

_writeHeaderFooter()

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

Write Header / Footer

Parameters

\PHPExcel_Shared_XMLWriter	$objWriter	XML Writer
\PHPExcel_Worksheet	$pSheet	Worksheet

Throws

\PHPExcel_Writer_Exception

Returns

mixed —

_writeBreaks()

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

Write Breaks

Parameters

\PHPExcel_Shared_XMLWriter	$objWriter	XML Writer
\PHPExcel_Worksheet	$pSheet	Worksheet

Throws

\PHPExcel_Writer_Exception

Returns

mixed —

_writeSheetData()

_writeSheetData(\PHPExcel_Shared_XMLWriter  $objWriter = null, \PHPExcel_Worksheet  $pSheet = null, string[]  $pStringTable = null) : mixed

Write SheetData

Parameters

\PHPExcel_Shared_XMLWriter	$objWriter	XML Writer
\PHPExcel_Worksheet	$pSheet	Worksheet
string[]	$pStringTable	String table

Throws

\PHPExcel_Writer_Exception

Returns

mixed —

_writeCell()

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

Write Cell

Parameters

\PHPExcel_Shared_XMLWriter	$objWriter	XML Writer
\PHPExcel_Worksheet	$pSheet	Worksheet
\PHPExcel_Cell	$pCellAddress	Cell Address
string[]	$pStringTable	String table
string[]	$pFlippedStringTable	String table (flipped), for faster index searching

Throws

\PHPExcel_Writer_Exception

Returns

mixed —

_writeDrawings()

_writeDrawings(\PHPExcel_Shared_XMLWriter  $objWriter = null, \PHPExcel_Worksheet  $pSheet = null, bool  $includeCharts = FALSE) : mixed

Write Drawings

Parameters

\PHPExcel_Shared_XMLWriter	$objWriter	XML Writer
\PHPExcel_Worksheet	$pSheet	Worksheet
bool	$includeCharts	Flag indicating if we should include drawing details for charts

Throws

\PHPExcel_Writer_Exception

Returns

mixed —

_writeLegacyDrawing()

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

Write LegacyDrawing

Parameters

\PHPExcel_Shared_XMLWriter	$objWriter	XML Writer
\PHPExcel_Worksheet	$pSheet	Worksheet

Throws

\PHPExcel_Writer_Exception

Returns

mixed —

_writeLegacyDrawingHF()

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

Write LegacyDrawingHF

Parameters

\PHPExcel_Shared_XMLWriter	$objWriter	XML Writer
\PHPExcel_Worksheet	$pSheet	Worksheet

Throws

\PHPExcel_Writer_Exception

Returns

mixed —

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