PHP中使用ExcelReader读取EXCEL日期字段的处理

ExcelReader是个简单易用的东东，相信很多使用PHP的同学们需要从EXCEL中导入数据到数据库时，十有八九都会使用它，因为他实在是简单易用，看看他的例子就知道了。

 

不过从EXCEL中导入日期类型的字段的时候，问题就来了，首先是时区的问题，还有格式的问题。从EXCEL中读出的都是“d/m/Y”的格式，MYSQL中我一般都用“Y-m-d”的格式。转换格式比较容易，修改 /Spreadsheet_Excel_Reader/Excel/reader.php中的

 

var $dateFormats = array (         0xe => "d/m/Y",         0xf => "d-M-Y",         0x10 => "d-M",         0x11 => "M-Y",         0x12 => "h:i a",         0x13 => "h:i:s a",         0x14 => "H:i",         0x15 => "H:i:s",         0x16 => "d/m/Y H:i",         0x2d => "i:s",         0x2e => "H:i:s",         0x2f => "i:s.S");*/ 修改为 var $dateFormats = array (         0xe => "Y-m-d",         0xf => "Y-M-d",         0x10 => "M-d",         0x11 => "Y-M",         0x12 => "h:i a",         0x13 => "h:i:s a",         0x14 => "H:i",         0x15 => "H:i:s",         0x16 => "Y-m-d H:i",         0x2d => "i:s",         0x2e => "H:i:s",         0x2f => "i:s.S");

 

$ifile = $_GET['ifile'];$upfile_type = strtolower(pathinfo($ifile, PATHINFO_EXTENSION));if ($upfile_type != 'xls') { $mess = "{success:false, message:'您选择的文件类型不是有效的EXCEL文件！'}"; $mess = iconv("gb2312","utf-8//IGNORE",$mess); echo $mess; return;}

require_once '../ExcelReader/reader.php';

// ExcelFile($filename, $encoding);$data = new Spreadsheet_Excel_Reader();// Set output Encoding.$data->setOutputEncoding('CP936');

$data->read($ifile);

error_reporting(E_ALL ^ E_NOTICE);

...