$_uniqueID
$_uniqueID : string
Unique ID
PHPExcel
$_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
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) : \Sheet
Get index for sheet
| \PHPExcel_Worksheet | $pSheet |
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) : \PHPExcel
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|false
Get cellXf by hash code
| string | $pValue |
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 |
getCellStyleXfByHashCode(string $pValue = '') : \PHPExcel_Style|false
Get cellStyleXf by hash code
| string | $pValue |
addCellStyleXf(\PHPExcel_Style $pStyle)
Add a cellStyleXf to the workbook
| \PHPExcel_Style | $pStyle |