diff options
| author | Stanislau Wolski <stanislau.wolski@gmail.com> | 2012-12-17 16:21:15 +0300 |
|---|---|---|
| committer | Stanislau Wolski <stanislau.wolski@gmail.com> | 2012-12-17 16:21:15 +0300 |
| commit | 053bf3be069ba7edf53a91179e0cfc3cdb365544 (patch) | |
| tree | 69de5e8ec5812adf340565da22976f162de2cf42 /codebase/db_excel.php | |
| parent | ab115e55bc42d761356cefeb7f3568d47eeb5e40 (diff) | |
| parent | 4e84f2ec1bdff3009847aa2831417741f7a4fb1e (diff) | |
| download | connector-php-053bf3be069ba7edf53a91179e0cfc3cdb365544.zip connector-php-053bf3be069ba7edf53a91179e0cfc3cdb365544.tar.gz connector-php-053bf3be069ba7edf53a91179e0cfc3cdb365544.tar.bz2 | |
Merge branch 'master' of 192.168.1.251:connector-php
Diffstat (limited to 'codebase/db_excel.php')
| -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(); |