[ Index ]

PHP Cross Reference of vtigercrm-6.1.0

title

Body

[close]

/libraries/PHPExcel/ -> PHPExcel.php (summary)

PHPExcel Copyright (c) 2006 - 2012 PHPExcel

Copyright: Copyright (c) 2006 - 2012 PHPExcel (http://www.codeplex.com/PHPExcel)
License: http://www.gnu.org/licenses/old-licenses/lgpl-2.1.txt LGPL
Version: 1.7.7, 2012-05-19
File Size: 805 lines (19 kb)
Included or required: 1 time
Referenced: 0 times
Includes or requires: 1 file
 libraries/PHPExcel/PHPExcel/Autoloader.php

Defines 1 class

PHPExcel:: (41 methods):
  __construct()
  disconnectWorksheets()
  getProperties()
  setProperties()
  getSecurity()
  setSecurity()
  getActiveSheet()
  createSheet()
  addSheet()
  removeSheetByIndex()
  getSheet()
  getAllSheets()
  getSheetByName()
  getIndex()
  setIndexByName()
  getSheetCount()
  getActiveSheetIndex()
  setActiveSheetIndex()
  setActiveSheetIndexByName()
  getSheetNames()
  addExternalSheet()
  getNamedRanges()
  addNamedRange()
  getNamedRange()
  removeNamedRange()
  getWorksheetIterator()
  copy()
  __clone()
  getCellXfCollection()
  getCellXfByIndex()
  getCellXfByHashCode()
  getDefaultStyle()
  addCellXf()
  removeCellXfByIndex()
  getCellXfSupervisor()
  getCellStyleXfCollection()
  getCellStyleXfByIndex()
  getCellStyleXfByHashCode()
  addCellStyleXf()
  removeCellStyleXfByIndex()
  garbageCollect()


Class: PHPExcel  - X-Ref

PHPExcel

__construct()   X-Ref
Create a new PHPExcel with one Worksheet


disconnectWorksheets()   X-Ref
Disconnect all worksheets from this PHPExcel workbook object,
typically so that the PHPExcel object can be unset


getProperties()   X-Ref
Get properties

return: PHPExcel_DocumentProperties

setProperties(PHPExcel_DocumentProperties $pValue)   X-Ref
Set properties

param: PHPExcel_DocumentProperties    $pValue

getSecurity()   X-Ref
Get security

return: PHPExcel_DocumentSecurity

setSecurity(PHPExcel_DocumentSecurity $pValue)   X-Ref
Set security

param: PHPExcel_DocumentSecurity    $pValue

getActiveSheet()   X-Ref
Get active sheet

return: PHPExcel_Worksheet

createSheet($iSheetIndex = null)   X-Ref
Create sheet and add it to this workbook

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

addSheet(PHPExcel_Worksheet $pSheet = null, $iSheetIndex = null)   X-Ref
Add sheet

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

removeSheetByIndex($pIndex = 0)   X-Ref
Remove sheet by index

param: int $pIndex Active sheet index

getSheet($pIndex = 0)   X-Ref
Get sheet by index

param: int $pIndex Sheet index
return: PHPExcel_Worksheet

getAllSheets()   X-Ref
Get all sheets

return: PHPExcel_Worksheet[]

getSheetByName($pName = '')   X-Ref
Get sheet by name

param: string $pName Sheet name
return: PHPExcel_Worksheet

getIndex(PHPExcel_Worksheet $pSheet)   X-Ref
Get index for sheet

param: PHPExcel_Worksheet $pSheet
return: Sheet index

setIndexByName($sheetName, $newIndex)   X-Ref
Set index for sheet by sheet name.

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

getSheetCount()   X-Ref
Get sheet count

return: int

getActiveSheetIndex()   X-Ref
Get active sheet index

return: int Active sheet index

setActiveSheetIndex($pIndex = 0)   X-Ref
Set active sheet index

param: int $pIndex Active sheet index
return: PHPExcel_Worksheet

setActiveSheetIndexByName($pValue = '')   X-Ref
Set active sheet index by name

param: string $pValue Sheet title
return: PHPExcel_Worksheet

getSheetNames()   X-Ref
Get sheet names

return: string[]

addExternalSheet(PHPExcel_Worksheet $pSheet, $iSheetIndex = null)   X-Ref
Add external sheet

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

getNamedRanges()   X-Ref
Get named ranges

return: PHPExcel_NamedRange[]

addNamedRange(PHPExcel_NamedRange $namedRange)   X-Ref
Add named range

param: PHPExcel_NamedRange $namedRange
return: PHPExcel

getNamedRange($namedRange, PHPExcel_Worksheet $pSheet = null)   X-Ref
Get named range

param: string $namedRange
param: PHPExcel_Worksheet|null $pSheet Scope. Use null for global scope
return: PHPExcel_NamedRange|null

removeNamedRange($namedRange, PHPExcel_Worksheet $pSheet = null)   X-Ref
Remove named range

param: string  $namedRange
param: PHPExcel_Worksheet|null  $pSheet  Scope: use null for global scope.
return: PHPExcel

getWorksheetIterator()   X-Ref
Get worksheet iterator

return: PHPExcel_WorksheetIterator

copy()   X-Ref
Copy workbook (!= clone!)

return: PHPExcel

__clone()   X-Ref
Implement PHP __clone to create a deep clone, not just a shallow copy.


getCellXfCollection()   X-Ref
Get the workbook collection of cellXfs

return: PHPExcel_Style[]

getCellXfByIndex($pIndex = 0)   X-Ref
Get cellXf by index

param: int $pIndex
return: PHPExcel_Style

getCellXfByHashCode($pValue = '')   X-Ref
Get cellXf by hash code

param: string $pValue
return: PHPExcel_Style|false

getDefaultStyle()   X-Ref
Get default style

return: PHPExcel_Style

addCellXf(PHPExcel_Style $style)   X-Ref
Add a cellXf to the workbook

param: PHPExcel_Style $style

removeCellXfByIndex($pIndex = 0)   X-Ref
Remove cellXf by index. It is ensured that all cells get their xf index updated.

param: int $pIndex Index to cellXf

getCellXfSupervisor()   X-Ref
Get the cellXf supervisor

return: PHPExcel_Style

getCellStyleXfCollection()   X-Ref
Get the workbook collection of cellStyleXfs

return: PHPExcel_Style[]

getCellStyleXfByIndex($pIndex = 0)   X-Ref
Get cellStyleXf by index

param: int $pIndex
return: PHPExcel_Style

getCellStyleXfByHashCode($pValue = '')   X-Ref
Get cellStyleXf by hash code

param: string $pValue
return: PHPExcel_Style|false

addCellStyleXf(PHPExcel_Style $pStyle)   X-Ref
Add a cellStyleXf to the workbook

param: PHPExcel_Style $pStyle

removeCellStyleXfByIndex($pIndex = 0)   X-Ref
Remove cellStyleXf by index

param: int $pIndex

garbageCollect()   X-Ref
Eliminate all unneeded cellXf and afterwards update the xfIndex for all cells
and columns in the workbook




Generated: Fri Nov 28 20:08:37 2014 Cross-referenced by PHPXref 0.7.1