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

Class: PHPExcel

Source Location: /PHPExcel.php

Class Overview


PHPExcel


Author(s):

Copyright:

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

Variables

Methods



Class Details

[line 58]
PHPExcel

PHPExcel




Tags:

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


[ Top ]


Class Variables

$_activeSheetIndex =  0

[line 86]

Active sheet index

Active sheet index




Tags:

access:  private

Type:   int


[ Top ]

$_namedRanges = array()

[line 93]

Named ranges

Named ranges




Tags:

access:  private

Type:   PHPExcel_NamedRange[]


[ Top ]

$_properties =

[line 65]

Document properties

Document properties




Tags:

access:  private



[ Top ]

$_security =

[line 72]

Document security

Document security




Tags:

access:  private



[ Top ]

$_workSheetCollection = array()

[line 79]

Collection of Worksheet objects

Collection of Worksheet objects




Tags:

access:  private

Type:   PHPExcel_Worksheet[]


[ Top ]



Class Methods


constructor __construct [line 98]

PHPExcel __construct( )

Create a new PHPExcel with one Worksheet

Create a new PHPExcel with one Worksheet




Tags:

access:  public


[ Top ]

method addExternalSheet [line 323]

void addExternalSheet( $pSheet)

Add external sheet

Add external sheet




Tags:

throws:  Exception
access:  public


Parameters:

PHPExcel_Worksheet   $pSheet   External sheet to add

[ Top ]

method addNamedRange [line 346]

void addNamedRange( PHPExcel_NamedRange $namedRange)

Add named range

Add named range




Tags:

access:  public


Parameters:

PHPExcel_NamedRange   $namedRange  

[ Top ]

method addSheet [line 185]

void addSheet( [ $pSheet = null])

Add sheet

Add sheet




Tags:

throws:  Exception
access:  public


Parameters:

PHPExcel_Worksheet   $pSheet  

[ Top ]

method copy [line 388]

PHPExcel copy( )

Copy workbook (!= clone!)

Copy workbook (!= clone!)




Tags:

access:  public


[ Top ]

method createSheet [line 170]

PHPExcel_Worksheet createSheet( )

Create sheet and add it to this workbook

Create sheet and add it to this workbook




Tags:

access:  public


[ Top ]

method getActiveSheet [line 160]

PHPExcel_Worksheet getActiveSheet( )

Get active sheet

Get active sheet




Tags:

access:  public


[ Top ]

method getActiveSheetIndex [line 281]

int getActiveSheetIndex( )

Get active sheet index

Get active sheet index




Tags:

return:  Active sheet index
access:  public


[ Top ]

method getAllSheets [line 226]

PHPExcel_Worksheet[] getAllSheets( )

Get all sheets

Get all sheets




Tags:

access:  public


[ Top ]

method getIndex [line 257]

Sheet getIndex( $pSheet)

Get index for sheet

Get index for sheet




Tags:

return:  index
throws:  Exception
access:  public


Parameters:

PHPExcel_Worksheet   $pSheet  

[ Top ]

method getNamedRange [line 355]

void getNamedRange( string $namedRange)

Get named range

Get named range




Tags:

access:  public


Parameters:

string   $namedRange  

[ Top ]

method getNamedRanges [line 337]

PHPExcel_NamedRange[] getNamedRanges( )

Get named ranges

Get named ranges




Tags:

access:  public


[ Top ]

method getProperties [line 120]

PHPExcel_DocumentProperties getProperties( )

Get properties

Get properties




Tags:

access:  public


[ Top ]

method getSecurity [line 140]

PHPExcel_DocumentSecurity getSecurity( )

Get security

Get security




Tags:

access:  public


[ Top ]

method getSheet [line 212]

PHPExcel_Worksheet getSheet( [int $pIndex = 0])

Get sheet by index

Get sheet by index




Tags:

throws:  Exception
access:  public


Parameters:

int   $pIndex   Sheet index

[ Top ]

method getSheetByName [line 238]

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

Get sheet by name

Get sheet by name




Tags:

throws:  Exception
access:  public


Parameters:

string   $pName   Sheet name

[ Top ]

method getSheetCount [line 271]

int getSheetCount( )

Get sheet count

Get sheet count




Tags:

access:  public


[ Top ]

method getSheetNames [line 306]

string[] getSheetNames( )

Get sheet names

Get sheet names




Tags:

access:  public


[ Top ]

method getWorksheetIterator [line 379]

PHPExcel_WorksheetIterator getWorksheetIterator( )

Get worksheet iterator

Get worksheet iterator




Tags:

access:  public


[ Top ]

method removeNamedRange [line 368]

void removeNamedRange( string $namedRange)

Remove named range

Remove named range




Tags:

access:  public


Parameters:

string   $namedRange  

[ Top ]

method removeSheetByIndex [line 196]

void removeSheetByIndex( [int $pIndex = 0])

Remove sheet by index

Remove sheet by index




Tags:

throws:  Exception
access:  public


Parameters:

int   $pIndex   Active sheet index

[ Top ]

method setActiveSheetIndex [line 292]

void setActiveSheetIndex( [int $pIndex = 0])

Set active sheet index

Set active sheet index




Tags:

throws:  Exception
access:  public


Parameters:

int   $pIndex   Active sheet index

[ Top ]

method setProperties [line 130]

void setProperties( PHPExcel_DocumentProperties $pValue)

Set properties

Set properties




Tags:

access:  public


Parameters:

PHPExcel_DocumentProperties   $pValue  

[ Top ]

method setSecurity [line 150]

void setSecurity( PHPExcel_DocumentSecurity $pValue)

Set security

Set security




Tags:

access:  public


Parameters:

PHPExcel_DocumentSecurity   $pValue  

[ Top ]

method __clone [line 403]

void __clone( )

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

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




Tags:

access:  public


[ Top ]


Documentation generated on Wed, 22 Apr 2009 09:01:29 +0200 by phpDocumentor 1.4.1