diff options
| author | dmitry-radyno <dmitry.radyno@gmail.com> | 2012-10-18 18:22:00 +0200 |
|---|---|---|
| committer | dmitry-radyno <dmitry.radyno@gmail.com> | 2012-10-18 18:22:00 +0200 |
| commit | b1e405f48bd388b373a05aa29521098fc5171f34 (patch) | |
| tree | 76bb8b9cbc1290fbdc09932552640c0bc3e5b2d4 | |
| parent | a21541aebaccdef94197aa227b0917bf2320d701 (diff) | |
| download | connector-php-b1e405f48bd388b373a05aa29521098fc5171f34.zip connector-php-b1e405f48bd388b373a05aa29521098fc5171f34.tar.gz connector-php-b1e405f48bd388b373a05aa29521098fc5171f34.tar.bz2 | |
-fix db_excel + dates
| -rw-r--r-- | codebase/db_excel.php | 5 |
1 files changed, 4 insertions, 1 deletions
diff --git a/codebase/db_excel.php b/codebase/db_excel.php index 09db5b0..14050e1 100644 --- a/codebase/db_excel.php +++ b/codebase/db_excel.php @@ -34,6 +34,7 @@ class ExcelDBDataWrapper extends DBDataWrapper { public function select($source) { $path = $this->connection; $excel = PHPExcel_IOFactory::createReaderForFile($path); + $excel->setReadDataOnly(false); $excel = $excel->load($path); $excRes = new ExcelResult(); $excelWS = $excel->getActiveSheet(); @@ -68,7 +69,9 @@ class ExcelDBDataWrapper extends DBDataWrapper { for ($j = 0; $j < count($this->config->text); $j++) { $col = PHPExcel_Cell::columnIndexFromString($this->config->text[$j]['name']) - 1; $cell = $excelWS->getCellByColumnAndRow($col, $i); - if ($cell->getDataType() == 'f') { + if (PHPExcel_Shared_Date::isDateTime($cell)) { + $r[PHPExcel_Cell::stringFromColumnIndex($col)] = PHPExcel_Shared_Date::ExcelToPHP($cell->getValue()); + } else if ($cell->getDataType() == 'f') { $r[PHPExcel_Cell::stringFromColumnIndex($col)] = $cell->getCalculatedValue(); } else { $r[PHPExcel_Cell::stringFromColumnIndex($col)] = $cell->getValue(); |