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. More...
	bindValue (PHPExcel_Cell $cell, $value=NULL)
	Bind value to a cell. More...

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

Detailed Description

Definition at line 46 of file DefaultValueBinder.php.

Member Function Documentation

bindValue()

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.

    {
        // sanitize UTF-8 strings
        if (is_string($value)) {
            $value = PHPExcel_Shared_String::SanitizeUTF8($value);
        } elseif (is_object($value)) {
            // Handle any objects that might be injected
            if ($value instanceof DateTime) {
                $value = $value->format('Y-m-d H:i:s');
            } elseif (!($value instanceof PHPExcel_RichText)) {
                $value = (string) $value;
            }
        }
 
        // Set value explicit
        $cell->setValueExplicit( $value, self::dataTypeForValue($value) );
 
        // Done!
        return true;
    }

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

Here is the call graph for this function:

dataTypeForValue()

static PHPExcel_Cell_DefaultValueBinder::dataTypeForValue (   $pValue = null )

static

DataType for value.

Parameters

mixed

$pValue

Returns

string

Definition at line 82 of file DefaultValueBinder.php.

                                                            {
        // Match the value against a few data types
        if ($pValue === null) {
            return PHPExcel_Cell_DataType::TYPE_NULL;
        } elseif ($pValue === '') {
            return PHPExcel_Cell_DataType::TYPE_STRING;
        } elseif ($pValue instanceof PHPExcel_RichText) {
            return PHPExcel_Cell_DataType::TYPE_INLINE;
        } 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]+)([Ee][\-\+]?[0-2]?\d{1,3})?$/', $pValue)) {
            $tValue = ltrim($pValue, '+-');
            if (is_string($pValue) && $tValue{0} === '0' && strlen($tValue) > 1 && $tValue{1} !== '.' ) {
                return PHPExcel_Cell_DataType::TYPE_STRING;
            } elseif((strpos($pValue, '.') === false) && ($pValue > PHP_INT_MAX)) {
                return PHPExcel_Cell_DataType::TYPE_STRING;
            }
            return PHPExcel_Cell_DataType::TYPE_NUMERIC;
        } elseif (is_string($pValue) && array_key_exists($pValue, PHPExcel_Cell_DataType::getErrorCodes())) {
            return PHPExcel_Cell_DataType::TYPE_ERROR;
        }
 
        return PHPExcel_Cell_DataType::TYPE_STRING;
    }

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

Referenced by PHPExcel_Cell_DataType\dataTypeForValue().

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:

• libs/composer/vendor/phpoffice/phpexcel/Classes/PHPExcel/Cell/DefaultValueBinder.php