\PHPExcel_Writer_Excel2007_Worksheet

PHPExcel_Writer_Excel2007_Worksheet

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()
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: vendor/Execl/PHPExcel/Writer/Excel2007/Worksheet.php
Package: PHPExcel_Writer_Excel2007
Class hierarchy: \PHPExcel_Writer_Excel2007_WriterPart

\PHPExcel_Writer_Excel2007_Worksheet

Properties

$parentWriter

$parentWriter : \PHPExcel_Writer_IWriter

Parent IWriter object

Type

\PHPExcel_Writer_IWriter

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

writeWorksheet()

writeWorksheet(\PHPExcel_Worksheet  $pSheet = null, array<mixed,string>  $pStringTable = null, boolean  $includeCharts = false) : string

Write worksheet to XML format

Parameters

\PHPExcel_Worksheet	$pSheet
array<mixed,string>	$pStringTable
boolean	$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)

Write SheetPr

Parameters

\PHPExcel_Shared_XMLWriter	$objWriter	XML Writer
\PHPExcel_Worksheet	$pSheet	Worksheet

Throws

\PHPExcel_Writer_Exception

writeDimension()

writeDimension(\PHPExcel_Shared_XMLWriter  $objWriter = null, \PHPExcel_Worksheet  $pSheet = null)

Write Dimension

Parameters

\PHPExcel_Shared_XMLWriter	$objWriter	XML Writer
\PHPExcel_Worksheet	$pSheet	Worksheet

Throws

\PHPExcel_Writer_Exception

writeSheetViews()

writeSheetViews(\PHPExcel_Shared_XMLWriter  $objWriter = null, \PHPExcel_Worksheet  $pSheet = null)

Write SheetViews

Parameters

\PHPExcel_Shared_XMLWriter	$objWriter	XML Writer
\PHPExcel_Worksheet	$pSheet	Worksheet

Throws

\PHPExcel_Writer_Exception

writeSheetFormatPr()

writeSheetFormatPr(\PHPExcel_Shared_XMLWriter  $objWriter = null, \PHPExcel_Worksheet  $pSheet = null)

Write SheetFormatPr

Parameters

\PHPExcel_Shared_XMLWriter	$objWriter	XML Writer
\PHPExcel_Worksheet	$pSheet	Worksheet

Throws

\PHPExcel_Writer_Exception

writeCols()

writeCols(\PHPExcel_Shared_XMLWriter  $objWriter = null, \PHPExcel_Worksheet  $pSheet = null)

Write Cols

Parameters

\PHPExcel_Shared_XMLWriter	$objWriter	XML Writer
\PHPExcel_Worksheet	$pSheet	Worksheet

Throws

\PHPExcel_Writer_Exception

writeSheetProtection()

writeSheetProtection(\PHPExcel_Shared_XMLWriter  $objWriter = null, \PHPExcel_Worksheet  $pSheet = null)

Write SheetProtection

Parameters

\PHPExcel_Shared_XMLWriter	$objWriter	XML Writer
\PHPExcel_Worksheet	$pSheet	Worksheet

Throws

\PHPExcel_Writer_Exception

writeConditionalFormatting()

writeConditionalFormatting(\PHPExcel_Shared_XMLWriter  $objWriter = null, \PHPExcel_Worksheet  $pSheet = null)

Write ConditionalFormatting

Parameters

\PHPExcel_Shared_XMLWriter	$objWriter	XML Writer
\PHPExcel_Worksheet	$pSheet	Worksheet

Throws

\PHPExcel_Writer_Exception

writeDataValidations()

writeDataValidations(\PHPExcel_Shared_XMLWriter  $objWriter = null, \PHPExcel_Worksheet  $pSheet = null)

Write DataValidations

Parameters

\PHPExcel_Shared_XMLWriter	$objWriter	XML Writer
\PHPExcel_Worksheet	$pSheet	Worksheet

Throws

\PHPExcel_Writer_Exception

writeHyperlinks()

writeHyperlinks(\PHPExcel_Shared_XMLWriter  $objWriter = null, \PHPExcel_Worksheet  $pSheet = null)

Write Hyperlinks

Parameters

\PHPExcel_Shared_XMLWriter	$objWriter	XML Writer
\PHPExcel_Worksheet	$pSheet	Worksheet

Throws

\PHPExcel_Writer_Exception

writeProtectedRanges()

writeProtectedRanges(\PHPExcel_Shared_XMLWriter  $objWriter = null, \PHPExcel_Worksheet  $pSheet = null)

Write ProtectedRanges

Parameters

\PHPExcel_Shared_XMLWriter	$objWriter	XML Writer
\PHPExcel_Worksheet	$pSheet	Worksheet

Throws

\PHPExcel_Writer_Exception

writeMergeCells()

writeMergeCells(\PHPExcel_Shared_XMLWriter  $objWriter = null, \PHPExcel_Worksheet  $pSheet = null)

Write MergeCells

Parameters

\PHPExcel_Shared_XMLWriter	$objWriter	XML Writer
\PHPExcel_Worksheet	$pSheet	Worksheet

Throws

\PHPExcel_Writer_Exception

writePrintOptions()

writePrintOptions(\PHPExcel_Shared_XMLWriter  $objWriter = null, \PHPExcel_Worksheet  $pSheet = null)

Write PrintOptions

Parameters

\PHPExcel_Shared_XMLWriter	$objWriter	XML Writer
\PHPExcel_Worksheet	$pSheet	Worksheet

Throws

\PHPExcel_Writer_Exception

writePageMargins()

writePageMargins(\PHPExcel_Shared_XMLWriter  $objWriter = null, \PHPExcel_Worksheet  $pSheet = null)

Write PageMargins

Parameters

\PHPExcel_Shared_XMLWriter	$objWriter	XML Writer
\PHPExcel_Worksheet	$pSheet	Worksheet

Throws

\PHPExcel_Writer_Exception

writeAutoFilter()

writeAutoFilter(\PHPExcel_Shared_XMLWriter  $objWriter = null, \PHPExcel_Worksheet  $pSheet = null)

Write AutoFilter

Parameters

\PHPExcel_Shared_XMLWriter	$objWriter	XML Writer
\PHPExcel_Worksheet	$pSheet	Worksheet

Throws

\PHPExcel_Writer_Exception

writePageSetup()

writePageSetup(\PHPExcel_Shared_XMLWriter  $objWriter = null, \PHPExcel_Worksheet  $pSheet = null)

Write PageSetup

Parameters

\PHPExcel_Shared_XMLWriter	$objWriter	XML Writer
\PHPExcel_Worksheet	$pSheet	Worksheet

Throws

\PHPExcel_Writer_Exception

writeHeaderFooter()

writeHeaderFooter(\PHPExcel_Shared_XMLWriter  $objWriter = null, \PHPExcel_Worksheet  $pSheet = null)

Write Header / Footer

Parameters

\PHPExcel_Shared_XMLWriter	$objWriter	XML Writer
\PHPExcel_Worksheet	$pSheet	Worksheet

Throws

\PHPExcel_Writer_Exception

writeBreaks()

writeBreaks(\PHPExcel_Shared_XMLWriter  $objWriter = null, \PHPExcel_Worksheet  $pSheet = null)

Write Breaks

Parameters

\PHPExcel_Shared_XMLWriter	$objWriter	XML Writer
\PHPExcel_Worksheet	$pSheet	Worksheet

Throws

\PHPExcel_Writer_Exception

writeSheetData()

writeSheetData(\PHPExcel_Shared_XMLWriter  $objWriter = null, \PHPExcel_Worksheet  $pSheet = null, array<mixed,string>  $pStringTable = null)

Write SheetData

Parameters

\PHPExcel_Shared_XMLWriter	$objWriter	XML Writer
\PHPExcel_Worksheet	$pSheet	Worksheet
array<mixed,string>	$pStringTable	String table

Throws

\PHPExcel_Writer_Exception

writeCell()

writeCell(\PHPExcel_Shared_XMLWriter  $objWriter = null, \PHPExcel_Worksheet  $pSheet = null, \PHPExcel_Cell  $pCellAddress = null, array<mixed,string>  $pStringTable = null, array<mixed,string>  $pFlippedStringTable = null)

Write Cell

Parameters

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

Throws

\PHPExcel_Writer_Exception

writeDrawings()

writeDrawings(\PHPExcel_Shared_XMLWriter  $objWriter = null, \PHPExcel_Worksheet  $pSheet = null, boolean  $includeCharts = false)

Write Drawings

Parameters

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

Throws

\PHPExcel_Writer_Exception

writeLegacyDrawing()

writeLegacyDrawing(\PHPExcel_Shared_XMLWriter  $objWriter = null, \PHPExcel_Worksheet  $pSheet = null)

Write LegacyDrawing

Parameters

\PHPExcel_Shared_XMLWriter	$objWriter	XML Writer
\PHPExcel_Worksheet	$pSheet	Worksheet

Throws

\PHPExcel_Writer_Exception

writeLegacyDrawingHF()

writeLegacyDrawingHF(\PHPExcel_Shared_XMLWriter  $objWriter = null, \PHPExcel_Worksheet  $pSheet = null)

Write LegacyDrawingHF

Parameters

\PHPExcel_Shared_XMLWriter	$objWriter	XML Writer
\PHPExcel_Worksheet	$pSheet	Worksheet

Throws

\PHPExcel_Writer_Exception

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