Todo List
PHPExcel
[line 91]
Active sheet index
[line 119]
CellStyleXf collection
[line 112]
CellXf collection
[line 105]
CellXf supervisor
[line 98]
Named ranges
[line 70]
Document properties
[line 77]
Document security
[line 84]
Collection of Worksheet objects
PHPExcel __construct( )
Create a new PHPExcel with one Worksheet
void addCellStyleXf( $pStyle)
Add a cellStyleXf to the workbook
void addCellXf( $style)
Add a cellXf to the workbook
PHPExcel_Worksheet addExternalSheet( $pSheet, [int|null $iSheetIndex = null])
Add external sheet
PHPExcel addNamedRange( PHPExcel_NamedRange $namedRange)
Add named range
PHPExcel_Worksheet addSheet( [ $pSheet = null], [int|null $iSheetIndex = null])
Add sheet
PHPExcel copy( )
Copy workbook (!= clone!)
PHPExcel_Worksheet createSheet( [ $iSheetIndex = null])
Create sheet and add it to this workbook
void garbageCollect( )
Eliminate all unneeded cellXf and afterwards update the xfIndex for all cells and columns in the workbook
PHPExcel_Worksheet getActiveSheet( )
Get active sheet
int getActiveSheetIndex( )
Get active sheet index
PHPExcel_Worksheet[] getAllSheets( )
Get all sheets
PHPExcel_Style|false getCellStyleXfByHashCode( [string $pValue = ''])
Get cellStyleXf by hash code
PHPExcel_Style getCellStyleXfByIndex( [int $pIndex = 0])
Get cellStyleXf by index
PHPExcel_Style[] getCellStyleXfCollection( )
Get the workbook collection of cellStyleXfs
PHPExcel_Style|false getCellXfByHashCode( [string $pValue = ''])
Get cellXf by hash code
PHPExcel_Style getCellXfByIndex( [ $pIndex = 0], int $index)
Get cellXf by index
PHPExcel_Style[] getCellXfCollection( )
Get the workbook collection of cellXfs
PHPExcel_Style getCellXfSupervisor( )
Get the cellXf supervisor
PHPExcel_Style getDefaultStyle( )
Get default style
Sheet getIndex( $pSheet)
Get index for sheet
void getNamedRange( string $namedRange, [ $pSheet = null])
Get named range
PHPExcel_NamedRange[] getNamedRanges( )
Get named ranges
PHPExcel_DocumentProperties getProperties( )
Get properties
PHPExcel_DocumentSecurity getSecurity( )
Get security
PHPExcel_Worksheet getSheet( [int $pIndex = 0])
Get sheet by index
PHPExcel_Worksheet getSheetByName( [string $pName = ''])
Get sheet by name
int getSheetCount( )
Get sheet count
string[] getSheetNames( )
Get sheet names
PHPExcel_WorksheetIterator getWorksheetIterator( )
Get worksheet iterator
void removeCellStyleXfByIndex( [int $pIndex = 0])
Remove cellStyleXf by index
void removeCellXfByIndex( [int $pIndex = 0])
Remove cellXf by index. It is ensured that all cells get their xf index updated.
PHPExcel removeNamedRange( string $namedRange, [ $pSheet = null])
Remove named range
void removeSheetByIndex( [int $pIndex = 0])
Remove sheet by index
PHPExcel_Worksheet setActiveSheetIndex( [int $pIndex = 0])
Set active sheet index
New setIndexByName( string $sheetName, int $newIndex)
Set index for sheet by sheet name.
void setProperties( PHPExcel_DocumentProperties $pValue)
Set properties
void setSecurity( PHPExcel_DocumentSecurity $pValue)
Set security
void __clone( )
Implement PHP __clone to create a deep clone, not just a shallow copy.
