PHPExcel_Cell_DefaultValueBinder Class Reference

Inheritance diagram for PHPExcel_Cell_DefaultValueBinder:

Collaboration diagram for PHPExcel_Cell_DefaultValueBinder:

Public Member Functions
	bindValue (PHPExcel_Cell $cell, $value=null)
	Bind value to a cell.

Static Public Member Functions
static	dataTypeForValue ($pValue=null)
	DataType for value.

Detailed Description

Definition at line 46 of file DefaultValueBinder.php.

Member Function Documentation

PHPExcel_Cell_DefaultValueBinder::bindValue	(	PHPExcel_Cell	$cell,
			$value = null
	)

Bind value to a cell.

Parameters

PHPExcel_Cell	$cell	Cell to bind value to
mixed	$value	Value to bind in cell

Returns

boolean

Implements PHPExcel_Cell_IValueBinder.

Reimplemented in PHPExcel_Cell_AdvancedValueBinder.

Definition at line 55 of file DefaultValueBinder.php.

References PHPExcel_Cell_DataType\dataTypeForValue(), PHPExcel_Shared_String\SanitizeUTF8(), and PHPExcel_Cell\setValueExplicit().

        {
                // sanitize UTF-8 strings
                if (is_string($value)) {
                        $value = PHPExcel_Shared_String::SanitizeUTF8($value);
                }

                // Set value explicit
                $cell->setValueExplicit( $value, PHPExcel_Cell_DataType::dataTypeForValue($value) );

                // Done!
                return true;
        }

Here is the call graph for this function:

static PHPExcel_Cell_DefaultValueBinder::dataTypeForValue (   $pValue = null )

static

DataType for value.

Parameters

mixed

$pValue

Returns

int

Definition at line 75 of file DefaultValueBinder.php.

References PHPExcel_Cell_DataType\getErrorCodes(), PHPExcel_Cell_DataType\TYPE_BOOL, PHPExcel_Cell_DataType\TYPE_ERROR, PHPExcel_Cell_DataType\TYPE_FORMULA, PHPExcel_Cell_DataType\TYPE_NULL, PHPExcel_Cell_DataType\TYPE_NUMERIC, and PHPExcel_Cell_DataType\TYPE_STRING.

Referenced by PHPExcel_Cell_AdvancedValueBinder\bindValue().

                                                                {
                // Match the value against a few data types
                if (is_null($pValue)) {
                        return PHPExcel_Cell_DataType::TYPE_NULL;

                } elseif ($pValue === '') {
                        return PHPExcel_Cell_DataType::TYPE_STRING;

                } elseif ($pValue instanceof PHPExcel_RichText) {
                        return PHPExcel_Cell_DataType::TYPE_STRING;

                } elseif ($pValue{0} === '=' && strlen($pValue) > 1) {
                        return PHPExcel_Cell_DataType::TYPE_FORMULA;

                } elseif (is_bool($pValue)) {
                        return PHPExcel_Cell_DataType::TYPE_BOOL;

                } elseif (is_float($pValue) || is_int($pValue)) {
                        return PHPExcel_Cell_DataType::TYPE_NUMERIC;

                } elseif (preg_match('/^\-?([0-9]+\\.?[0-9]*|[0-9]*\\.?[0-9]+)$/', $pValue)) {
                        return PHPExcel_Cell_DataType::TYPE_NUMERIC;

                } elseif (is_string($pValue) && array_key_exists($pValue, PHPExcel_Cell_DataType::getErrorCodes())) {
                        return PHPExcel_Cell_DataType::TYPE_ERROR;

                } else {
                        return PHPExcel_Cell_DataType::TYPE_STRING;

                }
        }

Here is the call graph for this function:

Here is the caller graph for this function:

---

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

• Services/Excel/PHPExcel/1.7.6/Classes/PHPExcel/Cell/DefaultValueBinder.php