Class PHPExcel
PHPExcel
Category: PHPExcel
Copyright: Copyright (c) 2006 - 2014 PHPExcel (http://www.codeplex.com/PHPExcel)
License: LGPL
Located at controlador/include/phpexcel/PHPExcel.php
public
true
|
|
public
|
|
public
|
|
public
binary|null
|
|
public
|
|
public
true|false
|
|
public
binary|null
|
|
public
|
|
public
|
|
public
|
|
public
|
#
setRibbonBinObjects( $BinObjectsNames = NULL, $BinObjectsData = NULL )
store binaries ribbon objects (pictures) |
private
|
#
_getExtensionOnly( $ThePath )
return the extension of a filename. Internal use for a array_map callback (php<5.3 don't like lambda function) |
public
|
|
public
true|false
|
|
public
true|false
|
|
public
boolean
|
#
sheetCodeNameExists( string $pSheetCodeName )
Check if a sheet with a specified code name already exists |
public
|
#
getSheetByCodeName( string $pName = '' )
Get sheet by code name. Warning : sheet don't have always a code name ! |
public
|
|
public
|
|
public
|
#
disconnectWorksheets( )
Disconnect all worksheets from this PHPExcel workbook object, typically so that the PHPExcel object can be unset |
public
|
|
public
|
|
public
|
|
public
|
|
public
|
|
public
|
|
public
|
|
public
boolean
|
|
public
|
|
public
|
|
public
|
|
public
|
|
public
|
|
public
Sheet
|
|
public
New
|
|
public
integer
|
|
public
integer
|
|
public
|
|
public
|
|
public
string[]
|
|
public
|
#
addExternalSheet(
Add external sheet |
public
|
|
public
|
|
public
|
|
public
|
|
public
|
|
public
|
|
public
|
|
public
|
|
public
|
|
public
|
|
public
boolean
|
|
public
|
|
public
|
|
public
|
#
removeCellXfByIndex( integer $pIndex = 0 )
Remove cellXf by index. It is ensured that all cells get their xf index updated. |
public
|
|
public
|
|
public
|
|
public
|
|
public
|
|
public
|
|
public
|
#
garbageCollect( )
Eliminate all unneeded cellXf and afterwards update the xfIndex for all cells and columns in the workbook |
public
string
|
private
string
|
$_uniqueID
Unique ID |
|
private
|
$_properties
Document properties |
|
private
|
$_security
Document security |
|
private
|
$_workSheetCollection
Collection of Worksheet objects |
#
array()
|
private
|
$_calculationEngine
Calculation Engine |
#
NULL
|
private
integer
|
$_activeSheetIndex
Active sheet index |
#
0
|
private
|
$_namedRanges
Named ranges |
#
array()
|
private
|
$_cellXfSupervisor
CellXf supervisor |
|
private
|
$_cellXfCollection
CellXf collection |
#
array()
|
private
|
$_cellStyleXfCollection
CellStyleXf collection |
#
array()
|
private
boolean
|
$_hasMacros
_hasMacros : this workbook have macros ? |
#
FALSE
|
private
binary
|
$_macrosCode
_macrosCode : all macros code (the vbaProject.bin file, this include form, code, etc.), NULL if no macro |
#
NULL
|
private
binary
|
$_macrosCertificate
_macrosCertificate : if macros are signed, contains vbaProjectSignature.bin file, NULL if not signed |
#
NULL
|
private
null|string
|
$_ribbonXMLData
_ribbonXMLData : NULL if workbook is'nt Excel 2007 or not contain a customized UI |
#
NULL
|
private
null|array
|
$_ribbonBinObjects
_ribbonBinObjects : NULL if workbook is'nt Excel 2007 or not contain embedded objects (picture(s)) for Ribbon Elements ignored if $_ribbonXMLData is null |
#
NULL
|