$uniqueID
$uniqueID : string
Unique ID
PHPExcel
Copyright (c) 2006 - 2015 PHPExcel
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
$properties : \PHPExcel_DocumentProperties
Document properties
$security : \PHPExcel_DocumentSecurity
Document security
$workSheetCollection : array<mixed,\PHPExcel_Worksheet>
Collection of Worksheet objects
$calculationEngine : \PHPExcel_Calculation
Calculation Engine
$namedRanges : array<mixed,\PHPExcel_NamedRange>
Named ranges
$cellXfSupervisor : \PHPExcel_Style
CellXf supervisor
$cellXfCollection : array<mixed,\PHPExcel_Style>
CellXf collection
$cellStyleXfCollection : array<mixed,\PHPExcel_Style>
CellStyleXf collection
getSheetByCodeName(string $pName = '') : \PHPExcel_Worksheet
Get sheet by code name. Warning : sheet don't have always a code name !
| string | $pName | Sheet name |
getCalculationEngine() : \PHPExcel_Calculation
Return the calculation engine for this worksheet
getProperties() : \PHPExcel_DocumentProperties
Get properties
setProperties(\PHPExcel_DocumentProperties $pValue)
Set properties
| \PHPExcel_DocumentProperties | $pValue |
getSecurity() : \PHPExcel_DocumentSecurity
Get security
setSecurity(\PHPExcel_DocumentSecurity $pValue)
Set security
| \PHPExcel_DocumentSecurity | $pValue |
getActiveSheet() : \PHPExcel_Worksheet
Get active sheet
createSheet(integer|null $iSheetIndex = null) : \PHPExcel_Worksheet
Create sheet and add it to this workbook
| integer|null | $iSheetIndex | Index where sheet should go (0,1,..., or null for last) |
addSheet(\PHPExcel_Worksheet $pSheet, integer|null $iSheetIndex = null) : \PHPExcel_Worksheet
Add sheet
| \PHPExcel_Worksheet | $pSheet | |
| integer|null | $iSheetIndex | Index where sheet should go (0,1,..., or null for last) |
getSheet(integer $pIndex) : \PHPExcel_Worksheet
Get sheet by index
| integer | $pIndex | Sheet index |
getAllSheets() : array<mixed,\PHPExcel_Worksheet>
Get all sheets
getSheetByName(string $pName = '') : \PHPExcel_Worksheet
Get sheet by name
| string | $pName | Sheet name |
getIndex(\PHPExcel_Worksheet $pSheet) : integer
Get index for sheet
| \PHPExcel_Worksheet | $pSheet |
Sheet index
setActiveSheetIndex(integer $pIndex) : \PHPExcel_Worksheet
Set active sheet index
| integer | $pIndex | Active sheet index |
setActiveSheetIndexByName(string $pValue = '') : \PHPExcel_Worksheet
Set active sheet index by name
| string | $pValue | Sheet title |
addExternalSheet(\PHPExcel_Worksheet $pSheet, integer|null $iSheetIndex = null) : \PHPExcel_Worksheet
Add external sheet
| \PHPExcel_Worksheet | $pSheet | External sheet to add |
| integer|null | $iSheetIndex | Index where sheet should go (0,1,..., or null for last) |
getNamedRanges() : array<mixed,\PHPExcel_NamedRange>
Get named ranges
addNamedRange(\PHPExcel_NamedRange $namedRange) : boolean
Add named range
| \PHPExcel_NamedRange | $namedRange |
getNamedRange(string $namedRange, \PHPExcel_Worksheet|null $pSheet = null) : \PHPExcel_NamedRange|null
Get named range
| string | $namedRange | |
| \PHPExcel_Worksheet|null | $pSheet | Scope. Use null for global scope |
removeNamedRange(string $namedRange, \PHPExcel_Worksheet|null $pSheet = null) : \PHPExcel
Remove named range
| string | $namedRange | |
| \PHPExcel_Worksheet|null | $pSheet | Scope: use null for global scope. |
getWorksheetIterator() : \PHPExcel_WorksheetIterator
Get worksheet iterator
copy() : \PHPExcel
Copy workbook (!= clone!)
getCellXfCollection() : array<mixed,\PHPExcel_Style>
Get the workbook collection of cellXfs
getCellXfByIndex(integer $pIndex) : \PHPExcel_Style
Get cellXf by index
| integer | $pIndex |
getCellXfByHashCode(string $pValue = '') : \PHPExcel_Style|boolean
Get cellXf by hash code
| string | $pValue |
False if no match found
cellXfExists(\PHPExcel_Style $pCellStyle = null) : boolean
Check if style exists in style collection
| \PHPExcel_Style | $pCellStyle |
getDefaultStyle() : \PHPExcel_Style
Get default style
addCellXf(\PHPExcel_Style $style)
Add a cellXf to the workbook
| \PHPExcel_Style | $style |
getCellXfSupervisor() : \PHPExcel_Style
Get the cellXf supervisor
getCellStyleXfCollection() : array<mixed,\PHPExcel_Style>
Get the workbook collection of cellStyleXfs
getCellStyleXfByIndex(integer $pIndex) : \PHPExcel_Style
Get cellStyleXf by index
| integer | $pIndex | Index to cellXf |
getCellStyleXfByHashCode(string $pValue = '') : \PHPExcel_Style|boolean
Get cellStyleXf by hash code
| string | $pValue |
False if no match found
addCellStyleXf(\PHPExcel_Style $pStyle)
Add a cellStyleXf to the workbook
| \PHPExcel_Style | $pStyle |