PhpOffice\PhpSpreadsheet\Cell\DefaultValueBinder Class Reference

Inheritance diagram for PhpOffice\PhpSpreadsheet\Cell\DefaultValueBinder:

Collaboration diagram for PhpOffice\PhpSpreadsheet\Cell\DefaultValueBinder:

Public Member Functions
	bindValue (Cell $cell, $value)
	Bind value to a cell. More...

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

Detailed Description

Definition at line 9 of file DefaultValueBinder.php.

Member Function Documentation

bindValue()

PhpOffice\PhpSpreadsheet\Cell\DefaultValueBinder::bindValue	(	Cell	$cell,
			$value
	)

Bind value to a cell.

Parameters

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

Returns

bool

Implements PhpOffice\PhpSpreadsheet\Cell\IValueBinder.

Definition at line 19 of file DefaultValueBinder.php.

References PhpOffice\PhpSpreadsheet\Shared\StringHelper\sanitizeUTF8(), and PhpOffice\PhpSpreadsheet\Cell\Cell\setValueExplicit().

    {
        // sanitize UTF-8 strings
        if (is_string($value)) {
            $value = StringHelper::sanitizeUTF8($value);
        } elseif (is_object($value)) {
            // Handle any objects that might be injected
            if ($value instanceof DateTimeInterface) {
                $value = $value->format('Y-m-d H:i:s');
            } elseif (!($value instanceof RichText)) {
                $value = (string) $value;
            }
        }

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

        // Done!
        return true;
    }

Here is the call graph for this function:

dataTypeForValue()

static PhpOffice\PhpSpreadsheet\Cell\DefaultValueBinder::dataTypeForValue (   $value )

static

DataType for value.

Parameters

mixed

$value

Returns

string

Definition at line 47 of file DefaultValueBinder.php.

References PhpOffice\PhpSpreadsheet\Cell\DataType\getErrorCodes(), PhpOffice\PhpSpreadsheet\Cell\DataType\TYPE_BOOL, PhpOffice\PhpSpreadsheet\Cell\DataType\TYPE_ERROR, PhpOffice\PhpSpreadsheet\Cell\DataType\TYPE_FORMULA, PhpOffice\PhpSpreadsheet\Cell\DataType\TYPE_INLINE, PhpOffice\PhpSpreadsheet\Cell\DataType\TYPE_NULL, PhpOffice\PhpSpreadsheet\Cell\DataType\TYPE_NUMERIC, and PhpOffice\PhpSpreadsheet\Cell\DataType\TYPE_STRING.

    {
        // Match the value against a few data types
        if ($value === null) {
            return DataType::TYPE_NULL;
        } elseif (is_float($value) || is_int($value)) {
            return DataType::TYPE_NUMERIC;
        } elseif (is_bool($value)) {
            return DataType::TYPE_BOOL;
        } elseif ($value === '') {
            return DataType::TYPE_STRING;
        } elseif ($value instanceof RichText) {
            return DataType::TYPE_INLINE;
        } elseif (is_string($value) && $value[0] === '=' && strlen($value) > 1) {
            return DataType::TYPE_FORMULA;
        } elseif (preg_match('/^[\+\-]?(\d+\\.?\d*|\d*\\.?\d+)([Ee][\-\+]?[0-2]?\d{1,3})?$/', $value)) {
            $tValue = ltrim($value, '+-');
            if (is_string($value) && $tValue[0] === '0' && strlen($tValue) > 1 && $tValue[1] !== '.') {
                return DataType::TYPE_STRING;
            } elseif ((strpos($value, '.') === false) && ($value > PHP_INT_MAX)) {
                return DataType::TYPE_STRING;
            } elseif (!is_numeric($value)) {
                return DataType::TYPE_STRING;
            }

            return DataType::TYPE_NUMERIC;
        } elseif (is_string($value)) {
            $errorCodes = DataType::getErrorCodes();
            if (isset($errorCodes[$value])) {
                return DataType::TYPE_ERROR;
            }
        }

        return DataType::TYPE_STRING;
    }

Here is the call graph for this function:

---

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

• libs/composer/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Cell/DefaultValueBinder.php