File Source for AdvancedValueBinder.php

PHPExcel_Cell

# Source for file AdvancedValueBinder.php

Documentation is available at AdvancedValueBinder.php

1. <?php
2. /**
3. * PHPExcel
4. *
5. * Copyright (c) 2006 - 2011 PHPExcel
6. *
7. * This library is free software; you can redistribute it and/or
8. * modify it under the terms of the GNU Lesser General Public
9. * License as published by the Free Software Foundation; either
10. * version 2.1 of the License, or (at your option) any later version.
11. *
12. * This library is distributed in the hope that it will be useful,
13. * but WITHOUT ANY WARRANTY; without even the implied warranty of
14. * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
15. * Lesser General Public License for more details.
16. *
17. * You should have received a copy of the GNU Lesser General Public
18. * License along with this library; if not, write to the Free Software
19. * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA
20. *
21. * @category PHPExcel
22. * @package PHPExcel_Cell
23. * @copyright Copyright (c) 2006 - 2011 PHPExcel (http://www.codeplex.com/PHPExcel)
24. * @license http://www.gnu.org/licenses/old-licenses/lgpl-2.1.txt LGPL
25. * @version 1.7.6, 2011-02-27
26. */
29. /** PHPExcel root directory */
30. if (! defined('PHPEXCEL_ROOT')) {
31. /**
32. * @ignore
33. */
34. define('PHPEXCEL_ROOT', dirname(__FILE__) . '/../../');
35. require(PHPEXCEL_ROOT . 'PHPExcel/Autoloader.php');
36. }
39. /**
40. * PHPExcel_Cell_AdvancedValueBinder
41. *
42. * @category PHPExcel
43. * @package PHPExcel_Cell
44. * @copyright Copyright (c) 2006 - 2011 PHPExcel (http://www.codeplex.com/PHPExcel)
45. */
46. class PHPExcel_Cell_AdvancedValueBinder extends PHPExcel_Cell_DefaultValueBinder implements PHPExcel_Cell_IValueBinder
47. {
48. /**
49. * Bind value to a cell
50. *
51. * @param PHPExcel_Cell $cell Cell to bind value to
52. * @param mixed $value Value to bind in cell
53. * @return boolean
54. */
55. public function bindValue(PHPExcel_Cell $cell, $value = null)
56. {
57. // sanitize UTF-8 strings
58. if ( is_string($value)) {
59. $value = PHPExcel_Shared_String:: SanitizeUTF8($value);
60. }
62. // Find out data type
63. $dataType = parent:: dataTypeForValue($value);
65. // Style logic - strings
66. if ($dataType === PHPExcel_Cell_DataType:: TYPE_STRING && !$value instanceof PHPExcel_RichText) {
67. // Test for booleans using locale-setting
68. if ($value == PHPExcel_Calculation:: getTRUE()) {
69. $cell->setValueExplicit( True, PHPExcel_Cell_DataType:: TYPE_BOOL);
70. return true;
71. } elseif($value == PHPExcel_Calculation:: getFALSE()) {
72. $cell->setValueExplicit( False, PHPExcel_Cell_DataType:: TYPE_BOOL);
73. return true;
74. }
76. // Check for number in scientific format
77. if ( preg_match('/^'.PHPExcel_Calculation:: CALCULATION_REGEXP_NUMBER.'$/', $value)) {
78. $cell->setValueExplicit( (float) $value, PHPExcel_Cell_DataType:: TYPE_NUMERIC);
79. return true;
80. }
82. // Check for percentage
83. if ( preg_match('/^\-?[0-9]*\.?[0-9]*\s?\%$/', $value)) {
84. // Convert value to number
85. $cell->setValueExplicit( (float)str_replace('%', '', $value) / 100, PHPExcel_Cell_DataType:: TYPE_NUMERIC);
86. // Set style
87. $cell->getParent()->getStyle( $cell->getCoordinate() )->getNumberFormat()->setFormatCode( PHPExcel_Style_NumberFormat:: FORMAT_PERCENTAGE );
88. return true;
89. }
91. // Check for time without seconds e.g. '9:45', '09:45'
92. if ( preg_match('/^(\d|[0-1]\d|2[0-3]):[0-5]\d$/', $value)) {
93. list($h, $m) = explode(':', $value);
94. $days = $h / 24 + $m / 1440;
95. // Convert value to number
96. $cell->setValueExplicit($days, PHPExcel_Cell_DataType:: TYPE_NUMERIC);
97. // Set style
98. $cell->getParent()->getStyle( $cell->getCoordinate() )->getNumberFormat()->setFormatCode( PHPExcel_Style_NumberFormat:: FORMAT_DATE_TIME3 );
99. return true;
100. }
102. // Check for time with seconds '9:45:59', '09:45:59'
103. if ( preg_match('/^(\d|[0-1]\d|2[0-3]):[0-5]\d:[0-5]\d$/', $value)) {
104. list($h, $m, $s) = explode(':', $value);
105. $days = $h / 24 + $m / 1440 + $s / 86400;
106. // Convert value to number
107. $cell->setValueExplicit($days, PHPExcel_Cell_DataType:: TYPE_NUMERIC);
108. // Set style
109. $cell->getParent()->getStyle( $cell->getCoordinate() )->getNumberFormat()->setFormatCode( PHPExcel_Style_NumberFormat:: FORMAT_DATE_TIME4 );
110. return true;
111. }
113. // Check for datetime, e.g. '2008-12-31', '2008-12-31 15:59', '2008-12-31 15:59:10'
114. if (($d = PHPExcel_Shared_Date:: stringToExcel($value)) !== false) {
115. // Convert value to number
116. $cell->setValueExplicit($d, PHPExcel_Cell_DataType:: TYPE_NUMERIC);
117. // Determine style. Either there is a time part or not. Look for ':'
118. if ( strpos($value, ':') !== false) {
119. $formatCode = 'yyyy-mm-dd h:mm';
120. } else {
121. $formatCode = 'yyyy-mm-dd';
122. }
123. $cell->getParent()->getStyle( $cell->getCoordinate() )->getNumberFormat()->setFormatCode($formatCode);
124. return true;
125. }
127. // Check for newline character "\n"
128. if ( strpos($value, "\n") !== false) {
129. $value = PHPExcel_Shared_String:: SanitizeUTF8($value);
130. $cell->setValueExplicit($value, PHPExcel_Cell_DataType:: TYPE_STRING);
131. // Set style
132. $cell->getParent()->getStyle( $cell->getCoordinate() )->getAlignment()->setWrapText(true);
133. return true;
134. }
135. }
137. // Not bound yet? Use parent...
138. return parent:: bindValue($cell, $value);
139. }
140. }

Documentation generated on Sun, 27 Feb 2011 16:26:46 -0800 by phpDocumentor 1.4.3