PHPExcel
[ class tree: PHPExcel ] [ index: PHPExcel ] [ all elements ]

Class: PHPExcel

Source Location: /PHPExcel.php

Class Overview


PHPExcel


Author(s):

Copyright:

  • Copyright (c) 2006 - 2010 PHPExcel (http://www.codeplex.com/PHPExcel)

Methods



Class Details

[line 49]
PHPExcel



Tags:

copyright:  Copyright (c) 2006 - 2010 PHPExcel (http://www.codeplex.com/PHPExcel)


[ Top ]


Class Methods


constructor __construct [line 110]

PHPExcel __construct( )

Create a new PHPExcel with one Worksheet



Tags:

access:  public


[ Top ]

method addCellStyleXf [line 697]

void addCellStyleXf( $pStyle)

Add a cellStyleXf to the workbook



Tags:

access:  public


Parameters:

PHPExcel_Style   $pStyle  

[ Top ]

method addCellXf [line 608]

void addCellXf( $style)

Add a cellXf to the workbook



Tags:

access:  public


Parameters:

PHPExcel_Style   $style  

[ Top ]

method addExternalSheet [line 419]

PHPExcel_Worksheet addExternalSheet( $pSheet, [int|null $iSheetIndex = null])

Add external sheet



Tags:

throws:  Exception
access:  public


Parameters:

PHPExcel_Worksheet   $pSheet   External sheet to add
int|null   $iSheetIndex   Index where sheet should go (0,1,..., or null for last)

[ Top ]

method addNamedRange [line 459]

PHPExcel addNamedRange( PHPExcel_NamedRange $namedRange)

Add named range



Tags:

access:  public


Parameters:

PHPExcel_NamedRange   $namedRange  

[ Top ]

method addSheet [line 215]

PHPExcel_Worksheet addSheet( [ $pSheet = null], [int|null $iSheetIndex = null])

Add sheet



Tags:

throws:  Exception
access:  public


Parameters:

PHPExcel_Worksheet   $pSheet  
int|null   $iSheetIndex   Index where sheet should go (0,1,..., or null for last)

[ Top ]

method copy [line 529]

PHPExcel copy( )

Copy workbook (!= clone!)



Tags:

access:  public


[ Top ]

method createSheet [line 200]

PHPExcel_Worksheet createSheet( [ $iSheetIndex = null])

Create sheet and add it to this workbook



Tags:

access:  public


Parameters:

   $iSheetIndex  

[ Top ]

method disconnectWorksheets [line 136]

void disconnectWorksheets( )



Tags:

access:  public


[ Top ]

method garbageCollect [line 722]

void garbageCollect( )

Eliminate all unneeded cellXf and afterwards update the xfIndex for all cells

and columns in the workbook




Tags:

access:  public


[ Top ]

method getActiveSheet [line 190]

PHPExcel_Worksheet getActiveSheet( )

Get active sheet



Tags:

access:  public


[ Top ]

method getActiveSheetIndex [line 356]

int getActiveSheetIndex( )

Get active sheet index



Tags:

return:  Active sheet index
access:  public


[ Top ]

method getAllSheets [line 276]

PHPExcel_Worksheet[] getAllSheets( )

Get all sheets



Tags:

access:  public


[ Top ]

method getCellStyleXfByHashCode [line 682]

PHPExcel_Style|false getCellStyleXfByHashCode( [string $pValue = ''])

Get cellStyleXf by hash code



Tags:

access:  public


Parameters:

string   $pValue  

[ Top ]

method getCellStyleXfByIndex [line 671]

PHPExcel_Style getCellStyleXfByIndex( [int $pIndex = 0])

Get cellStyleXf by index



Tags:

access:  public


Parameters:

int   $pIndex  

[ Top ]

method getCellStyleXfCollection [line 660]

PHPExcel_Style[] getCellStyleXfCollection( )

Get the workbook collection of cellStyleXfs



Tags:

access:  public


[ Top ]

method getCellXfByHashCode [line 579]

PHPExcel_Style|false getCellXfByHashCode( [string $pValue = ''])

Get cellXf by hash code



Tags:

access:  public


Parameters:

string   $pValue  

[ Top ]

method getCellXfByIndex [line 568]

PHPExcel_Style getCellXfByIndex( [ $pIndex = 0], int $index)

Get cellXf by index



Tags:

access:  public


Parameters:

int   $index  
   $pIndex  

[ Top ]

method getCellXfCollection [line 557]

PHPExcel_Style[] getCellXfCollection( )

Get the workbook collection of cellXfs



Tags:

access:  public


[ Top ]

method getCellXfSupervisor [line 650]

PHPExcel_Style getCellXfSupervisor( )

Get the cellXf supervisor



Tags:

access:  public


[ Top ]

method getDefaultStyle [line 595]

PHPExcel_Style getDefaultStyle( )

Get default style



Tags:

throws:  Exception
access:  public


[ Top ]

method getIndex [line 307]

Sheet getIndex( $pSheet)

Get index for sheet



Tags:

return:  index
throws:  Exception
access:  public


Parameters:

PHPExcel_Worksheet   $pSheet  

[ Top ]

method getNamedRange [line 477]

PHPExcel_NamedRange|null getNamedRange( string $namedRange, [ $pSheet = null])

Get named range



Tags:

access:  public


Parameters:

string   $namedRange  
PHPExcel_Worksheet|null   $pSheet   Scope. Use null for global scope

[ Top ]

method getNamedRanges [line 449]

PHPExcel_NamedRange[] getNamedRanges( )

Get named ranges



Tags:

access:  public


[ Top ]

method getProperties [line 150]

PHPExcel_DocumentProperties getProperties( )

Get properties



Tags:

access:  public


[ Top ]

method getSecurity [line 170]

PHPExcel_DocumentSecurity getSecurity( )

Get security



Tags:

access:  public


[ Top ]

method getSheet [line 262]

PHPExcel_Worksheet getSheet( [int $pIndex = 0])

Get sheet by index



Tags:

throws:  Exception
access:  public


Parameters:

int   $pIndex   Sheet index

[ Top ]

method getSheetByName [line 288]

PHPExcel_Worksheet getSheetByName( [string $pName = ''])

Get sheet by name



Tags:

throws:  Exception
access:  public


Parameters:

string   $pName   Sheet name

[ Top ]

method getSheetCount [line 346]

int getSheetCount( )

Get sheet count



Tags:

access:  public


[ Top ]

method getSheetNames [line 400]

string[] getSheetNames( )

Get sheet names



Tags:

access:  public


[ Top ]

method getWorksheetIterator [line 520]

PHPExcel_WorksheetIterator getWorksheetIterator( )

Get worksheet iterator



Tags:

access:  public


[ Top ]

method removeCellStyleXfByIndex [line 709]

void removeCellStyleXfByIndex( [int $pIndex = 0])

Remove cellStyleXf by index



Tags:

throws:  Exception
access:  public


Parameters:

int   $pIndex  

[ Top ]

method removeCellXfByIndex [line 620]

void removeCellXfByIndex( [int $pIndex = 0])

Remove cellXf by index. It is ensured that all cells get their xf index updated.



Tags:

throws:  Exception
access:  public


Parameters:

int   $pIndex   Index to cellXf

[ Top ]

method removeNamedRange [line 502]

PHPExcel removeNamedRange( string $namedRange, [ $pSheet = null], PHPExcel_Worksheet|null $pSheet.)

Remove named range



Tags:

access:  public


Parameters:

string   $namedRange  
PHPExcel_Worksheet|null   $pSheet.   Scope. Use null for global scope.
PHPExcel_Worksheet   $pSheet  

[ Top ]

method removeSheetByIndex [line 246]

void removeSheetByIndex( [int $pIndex = 0])

Remove sheet by index



Tags:

throws:  Exception
access:  public


Parameters:

int   $pIndex   Active sheet index

[ Top ]

method setActiveSheetIndex [line 368]

PHPExcel_Worksheet setActiveSheetIndex( [int $pIndex = 0])

Set active sheet index



Tags:

throws:  Exception
access:  public


Parameters:

int   $pIndex   Active sheet index

[ Top ]

method setActiveSheetIndexByName [line 385]

PHPExcel_Worksheet setActiveSheetIndexByName( [string $pValue = ''])

Set active sheet index by name



Tags:

throws:  Exception
access:  public


Parameters:

string   $pValue   Sheet title

[ Top ]

method setIndexByName [line 324]

New setIndexByName( string $sheetName, int $newIndex)

Set index for sheet by sheet name.



Tags:

return:  sheet index
throws:  Exception
access:  public


Parameters:

string   $sheetName   Sheet name to modify index for
int   $newIndex   New index for the sheet

[ Top ]

method setProperties [line 160]

void setProperties( PHPExcel_DocumentProperties $pValue)

Set properties



Tags:

access:  public


Parameters:

PHPExcel_DocumentProperties   $pValue  

[ Top ]

method setSecurity [line 180]

void setSecurity( PHPExcel_DocumentSecurity $pValue)

Set security



Tags:

access:  public


Parameters:

PHPExcel_DocumentSecurity   $pValue  

[ Top ]

method __clone [line 544]

void __clone( )

Implement PHP __clone to create a deep clone, not just a shallow copy.



Tags:

access:  public


[ Top ]


Documentation generated on Tue, 01 Jun 2010 17:05:40 +0200 by phpDocumentor 1.4.3