Todo List
PHPExcel
[line 86]
Active sheet index
[line 93]
Named ranges
[line 65]
Document properties
[line 72]
Document security
[line 79]
Collection of Worksheet objects
PHPExcel __construct( )
Create a new PHPExcel with one Worksheet
void addExternalSheet( $pSheet)
Add external sheet
void addNamedRange( PHPExcel_NamedRange $namedRange)
Add named range
void addSheet( [ $pSheet = null])
Add sheet
PHPExcel copy( )
Copy workbook (!= clone!)
PHPExcel_Worksheet createSheet( )
Create sheet and add it to this workbook
PHPExcel_Worksheet getActiveSheet( )
Get active sheet
int getActiveSheetIndex( )
Get active sheet index
PHPExcel_Worksheet[] getAllSheets( )
Get all sheets
Sheet getIndex( $pSheet)
Get index for sheet
void getNamedRange( string $namedRange)
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 removeNamedRange( string $namedRange)
Remove named range
void removeSheetByIndex( [int $pIndex = 0])
Remove sheet by index
void setActiveSheetIndex( [int $pIndex = 0])
Set active sheet index
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.