PHPExcel_Calculation_Function Class Reference

Collaboration diagram for PHPExcel_Calculation_Function:

Public Member Functions
	__construct ($pCategory=null, $pExcelName=null, $pPHPExcelName=null)
	Create a new PHPExcel_Calculation_Function.
	getCategory ()
	Get Category (represented by CATEGORY_*)
	setCategory ($value=null)
	Set Category (represented by CATEGORY_*)
	getExcelName ()
	Get Excel name.
	setExcelName ($value)
	Set Excel name.
	getPHPExcelName ()
	Get PHPExcel name.
	setPHPExcelName ($value)
	Set PHPExcel name.

Data Fields
const	CATEGORY_CUBE = 'Cube'
const	CATEGORY_DATABASE = 'Database'
const	CATEGORY_DATE_AND_TIME = 'Date and Time'
const	CATEGORY_ENGINEERING = 'Engineering'
const	CATEGORY_FINANCIAL = 'Financial'
const	CATEGORY_INFORMATION = 'Information'
const	CATEGORY_LOGICAL = 'Logical'
const	CATEGORY_LOOKUP_AND_REFERENCE = 'Lookup and Reference'
const	CATEGORY_MATH_AND_TRIG = 'Math and Trig'
const	CATEGORY_STATISTICAL = 'Statistical'
const	CATEGORY_TEXT_AND_DATA = 'Text and Data'

Private Attributes
	$_category
	$_excelName
	$_phpExcelName

Detailed Description

Definition at line 36 of file Function.php.

Constructor & Destructor Documentation

PHPExcel_Calculation_Function::__construct	(		$pCategory = null,
			$pExcelName = null,
			$pPHPExcelName = null
	)

Create a new PHPExcel_Calculation_Function.

Parameters

string	$pCategory	Category (represented by CATEGORY_*)
string	$pExcelName	Excel function name
string	$pPHPExcelName	PHPExcel function mapping

Exceptions

Exception

Definition at line 79 of file Function.php.

    {
        if (!is_null($pCategory) && !is_null($pExcelName) && !is_null($pPHPExcelName)) {
                // Initialise values
                $this->_category                = $pCategory;
                $this->_excelName               = $pExcelName;
                $this->_phpExcelName    = $pPHPExcelName;
        } else {
                throw new Exception("Invalid parameters passed.");
        }
    }

Member Function Documentation

PHPExcel_Calculation_Function::getCategory

(

)

Get Category (represented by CATEGORY_*)

Returns

string

Definition at line 96 of file Function.php.

References $_category.

                                  {
        return $this->_category;
    }

PHPExcel_Calculation_Function::getExcelName

(

)

Get Excel name.

Returns

string

Definition at line 119 of file Function.php.

References $_excelName.

                                   {
        return $this->_excelName;
    }

PHPExcel_Calculation_Function::getPHPExcelName

(

)

Get PHPExcel name.

Returns

string

Definition at line 137 of file Function.php.

References $_phpExcelName.

                                      {
        return $this->_phpExcelName;
    }

PHPExcel_Calculation_Function::setCategory

(

$value = null

)

Set Category (represented by CATEGORY_*)

Parameters

string

$value

Exceptions

Exception

Definition at line 106 of file Function.php.

                                               {
        if (!is_null($value)) {
                $this->_category = $value;
        } else {
                throw new Exception("Invalid parameter passed.");
        }
    }

PHPExcel_Calculation_Function::setExcelName

(

$value

)

Set Excel name.

Parameters

string

$value

Definition at line 128 of file Function.php.

                                         {
        $this->_excelName = $value;
    }

PHPExcel_Calculation_Function::setPHPExcelName

(

$value

)

Set PHPExcel name.

Parameters

string

$value

Definition at line 146 of file Function.php.

                                            {
        $this->_phpExcelName = $value;
    }

Field Documentation

PHPExcel_Calculation_Function::$_category

private

Definition at line 55 of file Function.php.

Referenced by getCategory().

PHPExcel_Calculation_Function::$_excelName

private

Definition at line 62 of file Function.php.

Referenced by getExcelName().

PHPExcel_Calculation_Function::$_phpExcelName

private

Definition at line 69 of file Function.php.

Referenced by getPHPExcelName().

const PHPExcel_Calculation_Function::CATEGORY_CUBE = 'Cube'

Definition at line 38 of file Function.php.

const PHPExcel_Calculation_Function::CATEGORY_DATABASE = 'Database'

Definition at line 39 of file Function.php.

const PHPExcel_Calculation_Function::CATEGORY_DATE_AND_TIME = 'Date and Time'

Definition at line 40 of file Function.php.

const PHPExcel_Calculation_Function::CATEGORY_ENGINEERING = 'Engineering'

Definition at line 41 of file Function.php.

const PHPExcel_Calculation_Function::CATEGORY_FINANCIAL = 'Financial'

Definition at line 42 of file Function.php.

const PHPExcel_Calculation_Function::CATEGORY_INFORMATION = 'Information'

Definition at line 43 of file Function.php.

const PHPExcel_Calculation_Function::CATEGORY_LOGICAL = 'Logical'

Definition at line 44 of file Function.php.

const PHPExcel_Calculation_Function::CATEGORY_LOOKUP_AND_REFERENCE = 'Lookup and Reference'

Definition at line 45 of file Function.php.

const PHPExcel_Calculation_Function::CATEGORY_MATH_AND_TRIG = 'Math and Trig'

Definition at line 46 of file Function.php.

const PHPExcel_Calculation_Function::CATEGORY_STATISTICAL = 'Statistical'

Definition at line 47 of file Function.php.

const PHPExcel_Calculation_Function::CATEGORY_TEXT_AND_DATA = 'Text and Data'

Definition at line 48 of file Function.php.

---

The documentation for this class was generated from the following file:

• Services/Excel/classes/PHPExcel/Calculation/Function.php