Docs For Class PHPExcel

static method getArrayReturnType [line 1713]

static string getArrayReturnType(
)

Return the Array Return Type (Array or Value of first element in the array)

Tags:

return:	Array return type
access:	public

[ Top ]

static method getInstance [line 1669]

static PHPExcel_Calculation getInstance(
)

Get an instance of this class

Tags:

access:

public

[ Top ]

static method setArrayReturnType [line 1696]

static boolean setArrayReturnType(
string
$returnType)

Set the Array Return Type (Array or Value of first element in the array)

Tags:

return:	Success or failure
access:	public

Parameters:

string

$returnType

Array return type

[ Top ]

static method _getMatrixDimensions [line 2314]

static array _getMatrixDimensions(
mixed
&$matrix)

Read the dimensions of a matrix, and re-index it with straight numeric keys starting from row 0, column 0

Tags:

return:	An array comprising the number of rows, and number of columns
access:	public

Parameters:

mixed

&$matrix

matrix operand

[ Top ]

static method _localeFunc [line 1978]

static void _localeFunc(

$function)

Tags:

access:

public

Parameters:

$function

[ Top ]

static method _translateSeparator [line 1874]

static void _translateSeparator(

$fromSeparator, 
$toSeparator, 
$formula, 
&$inBraces)

Tags:

access:

public

Parameters:

	$fromSeparator
	$toSeparator
	$formula
	&$inBraces

[ Top ]

static method _unwrapResult [line 2023]

static mixed _unwrapResult(
mixed
$value)

Remove quotes used as a wrapper to identify string values

Tags:

access:

public

Parameters:

mixed

$value

[ Top ]

static method _wrapResult [line 1999]

static mixed _wrapResult(
mixed
$value)

Wrap string values in quotes

Tags:

access:

public

Parameters:

mixed

$value

[ Top ]

method calculate [line 2047]

mixed calculate(
[
$pCell = null])

Calculate cell value (using formula from a cell ID) Retained for backward compatibility

Tags:

throws:	Exception
access:	public

Parameters:

PHPExcel_Cell

$pCell

Cell to calculate

[ Top ]

method calculateCellValue [line 2065]

mixed calculateCellValue(
[
$pCell = null], [Boolean
$resetLog = true])

Calculate the value of a cell formula

Tags:

throws:	Exception
access:	public

Parameters:

PHPExcel_Cell	$pCell	Cell to calculate
Boolean	$resetLog	Flag indicating whether the debug log should be reset or not

[ Top ]

method calculateFormula [line 2150]

mixed calculateFormula(
string
$formula, [
$cellID = null], [
$pCell = null])

Calculate the value of a formula

Tags:

throws:	Exception
access:	public

Parameters:

string	$formula	Formula to parse
	$cellID
PHPExcel_Cell	$pCell

[ Top ]

constructor __construct [line 1652]

PHPExcel_Calculation __construct(
)

[ Top ]

method clearCalculationCache [line 1760]

void clearCalculationCache(
)

Clear calculation cache

Tags:

access:

public

[ Top ]

method disableCalculationCache [line 1752]

void disableCalculationCache(
)

Disable calculation cache

Tags:

access:

public

[ Top ]

method enableCalculationCache [line 1744]

void enableCalculationCache(
)

Enable calculation cache

Tags:

access:

public

[ Top ]

method extractCellRange [line 3440]

mixed extractCellRange(
[string
&$pRange = 'A1'], [
$pSheet = null], [
$resetLog = true])

Extract range values

Tags:

return:	Array of values in range if range contains more than one element. Otherwise, a single value is returned.
throws:	Exception
access:	public

Parameters:

string	&$pRange	String based range representation
PHPExcel_Worksheet	$pSheet	Worksheet
	$resetLog

[ Top ]

method extractNamedRange [line 3495]

mixed extractNamedRange(
[string
&$pRange = 'A1'], [
$pSheet = null], [
$resetLog = true])

Extract range values

Tags:

return:	Array of values in range if range contains more than one element. Otherwise, a single value is returned.
throws:	Exception
access:	public

Parameters:

string	&$pRange	String based range representation
PHPExcel_Worksheet	$pSheet	Worksheet
	$resetLog

[ Top ]

method getCalculationCacheEnabled [line 1724]

boolean getCalculationCacheEnabled(
)

Is calculation caching enabled?

Tags:

access:

public

[ Top ]

method getCalculationCacheExpirationTime [line 1770]

float getCalculationCacheExpirationTime(
)

Get calculation cache expiration time

Tags:

access:

public

[ Top ]

method getLocale [line 1792]

string getLocale(
)

Get the currently defined locale code

Tags:

access:

public

[ Top ]

method isImplemented [line 3567]

boolean isImplemented(
[string
$pFunction = ''])

Is a specific function implemented?

Tags:

access:

public

Parameters:

string

$pFunction

Function Name

[ Top ]

method listFunctionNames [line 3605]

array listFunctionNames(
)

Get a list of implemented Excel function names

Tags:

access:

public

[ Top ]

method listFunctions [line 3582]

array listFunctions(
)

Get a list of all implemented functions as an array of function objects

Tags:

return:	of PHPExcel_Calculation_Function
access:	public

[ Top ]

method parseFormula [line 2129]

array parseFormula(
string
$formula)

Validate and parse a formula string

Tags:

throws:	Exception
access:	public

Parameters:

string

$formula

Formula to parse

[ Top ]

method setCalculationCacheEnabled [line 1735]

void setCalculationCacheEnabled(
[boolean
$pValue = true])

Enable/disable calculation cache

Tags:

access:

public

Parameters:

boolean

$pValue

[ Top ]

method setCalculationCacheExpirationTime [line 1780]

void setCalculationCacheExpirationTime(
[float
$pValue = 2.5])

Set calculation cache expiration time

Tags:

access:

public

Parameters:

float

$pValue

[ Top ]

method setLocale [line 1802]

boolean setLocale(
[
$locale = 'en_us'])

Set the locale code

Tags:

access:

public

Parameters:

$locale

[ Top ]

method _calculateFormulaValue [line 2182]

mixed _calculateFormulaValue(
string
$formula, [string
$cellID = null], [
$pCell = null])

Parse a cell formula and calculate its value

Tags:

throws:	Exception
access:	public

Parameters:

string	$formula	The formula to parse and calculate
string	$cellID	The ID (e.g. A3) of the cell that we are calculating
PHPExcel_Cell	$pCell	Cell to calculate

[ Top ]

method _raiseFormulaError [line 3425]

void _raiseFormulaError(

$errorMessage)

Tags:

access:

protected

Parameters:

$errorMessage

[ Top ]

method _translateFormulaToEnglish [line 1953]

void _translateFormulaToEnglish(

$formula)

Tags:

access:

public

Parameters:

$formula

[ Top ]

method _translateFormulaToLocale [line 1924]

void _translateFormulaToLocale(

$formula)

Tags:

access:

public

Parameters:

$formula

[ Top ]

method __clone [line 1684]

void __clone(
)

__clone implementation. Cloning should not be allowed in a Singleton!

Tags:

throws:	Exception
access:	public

[ Top ]

Class: PHPExcel_Calculation

Class Overview

Author(s):

Copyright:

Variables

Constants

Methods

Class Details

Tags:

Class Variables

$cyclicFormulaCount = 0

Tags:

$debugLog = array()

Tags:

$formulaError = null

Tags:

$suppressFormulaErrors = false

Tags:

$writeDebugLog = false

Tags:

Class Methods

static method getArrayReturnType [line 1713]

Tags:

static method getInstance [line 1669]

Tags:

static method setArrayReturnType [line 1696]

Tags:

Parameters:

static method _getMatrixDimensions [line 2314]

Tags:

Parameters:

static method _localeFunc [line 1978]

Tags:

Parameters:

static method _translateSeparator [line 1874]

Tags:

Parameters:

static method _unwrapResult [line 2023]

Tags:

Parameters:

static method _wrapResult [line 1999]

Tags:

Parameters:

method calculate [line 2047]

Tags:

Parameters:

method calculateCellValue [line 2065]

Tags:

Parameters:

method calculateFormula [line 2150]

Tags:

Parameters:

constructor __construct [line 1652]

method clearCalculationCache [line 1760]

Tags:

method disableCalculationCache [line 1752]

Tags:

method enableCalculationCache [line 1744]

Tags:

method extractCellRange [line 3440]

Tags:

Parameters:

method extractNamedRange [line 3495]

Tags:

Parameters:

method getCalculationCacheEnabled [line 1724]

Tags:

method getCalculationCacheExpirationTime [line 1770]

Tags:

method getLocale [line 1792]

Tags:

method isImplemented [line 3567]

Tags:

Parameters:

method listFunctionNames [line 3605]

Tags:

method listFunctions [line 3582]

Tags:

method parseFormula [line 2129]

Tags:

CALCULATION_REGEXP_CELLREF = '(((\w)|(\'[^\']\')|(\"[^\"]*\"))!)?\$?([a-z]{1,3})\$?(\d+)'

CALCULATION_REGEXP_FUNCTION = '@?([A-Z][A-Z0-9\.])[\s]\('

CALCULATION_REGEXP_NAMEDRANGE = '(((\w)|(\'.\')|(\".\"))!)?([_A-Z][_A-Z0-9])'