Blame view

src/lib/PHPExcel/Cell/DefaultValueBinder.php 3.38 KB
1ea3b987   Administrator   maby first commit
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
  <?php

  /**

   * PHPExcel

   *

   * Copyright (c) 2006 - 2014 PHPExcel

   *

   * This library is free software; you can redistribute it and/or

   * modify it under the terms of the GNU Lesser General Public

   * License as published by the Free Software Foundation; either

   * version 2.1 of the License, or (at your option) any later version.

   *

   * This library is distributed in the hope that it will be useful,

   * but WITHOUT ANY WARRANTY; without even the implied warranty of

   * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU

   * Lesser General Public License for more details.

   *

   * You should have received a copy of the GNU Lesser General Public

   * License along with this library; if not, write to the Free Software

   * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301  USA

   *

   * @category   PHPExcel

   * @package    PHPExcel_Cell

   * @copyright  Copyright (c) 2006 - 2014 PHPExcel (http://www.codeplex.com/PHPExcel)

   * @license    http://www.gnu.org/licenses/old-licenses/lgpl-2.1.txt    LGPL

   * @version    1.8.0, 2014-03-02

   */

  

  

  /** PHPExcel root directory */

  if (!defined('PHPEXCEL_ROOT')) {

      /**

       * @ignore

       */

      define('PHPEXCEL_ROOT', dirname(__FILE__) . '/../../');

      require(PHPEXCEL_ROOT . 'PHPExcel/Autoloader.php');

  }

  

  

  /**

   * PHPExcel_Cell_DefaultValueBinder

   *

   * @category   PHPExcel

   * @package    PHPExcel_Cell

   * @copyright  Copyright (c) 2006 - 2014 PHPExcel (http://www.codeplex.com/PHPExcel)

   */

  class PHPExcel_Cell_DefaultValueBinder implements PHPExcel_Cell_IValueBinder

  {

      /**

       * Bind value to a cell

       *

       * @param  PHPExcel_Cell  $cell   Cell to bind value to

       * @param  mixed          $value  Value to bind in cell

       * @return boolean

       */

      public function bindValue(PHPExcel_Cell $cell, $value = null)

      {

          // sanitize UTF-8 strings

          if (is_string($value)) {

              $value = PHPExcel_Shared_String::SanitizeUTF8($value);

          }

  

          // Set value explicit

          $cell->setValueExplicit( $value, self::dataTypeForValue($value) );

  

          // Done!

          return TRUE;

      }

  

      /**

       * DataType for value

       *

       * @param   mixed  $pValue

       * @return  string

       */

      public static function dataTypeForValue($pValue = null) {

          // 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_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]+)$/', $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;

  

          }

      }

  }