PHPExcel读取Excel 时间

来源:互联网 发布:java接口安全 编辑:程序博客网 时间:2024/06/10 18:08

PHPExcel读取Excel 时间

//读取Excel文件$info = pathinfo ( $path );$ext = $info ['extension'];$excelReader = null;if ( $ext == 'xls' )    $excelReader = new  PHPExcel_Reader_Excel5();else    $excelReader = new  PHPExcel_Reader_Excel2007();$phpExcelInstance = $excelReader->load($path);$sheet = $phpExcelInstance -> getSheet ( 0 );// 读取第一個工作表$highestRow = $sheet->getHighestRow(); // 取得总行数$highestColumm = $sheet->getHighestColumn(); // 取得总列数/** 循环读取每个单元格的数据 **/$arr = array ();for ( $row = 2 ; $row <= $highestRow ; $row ++ ){ // 行数是以第2行开始    $cell = $sheet->getCellByColumnAndRow(0, $row);    $value = $cell->getValue();    $date_value = '';    if ($cell->getDataType()==PHPExcel_Cell_DataType::TYPE_NUMERIC)    {        $cellstyleformat=$cell->getStyle()->getNumberFormat(); //获取cell类型        $formatcode=$cellstyleformat->getFormatCode(); //获取cell格式代码,时间格式为mm-dd-yy        if (preg_match('/^(\[\$[A-Z]*-[0-9A-F]*\])*[hmsdy]/i', $formatcode))        {            $date_value = gmdate("Y-m-d", PHPExcel_Shared_Date::ExcelToPHP($value));        }        else        {            $date_value = PHPExcel_Style_NumberFormat::toFormattedString($value,$formatcode);        }    }    elseif($cell->getDataType() == PHPExcel_Cell_DataType::TYPE_STRING)    {        $date = date_create($value);        if ($date)        {            $date_value = date_format($date,"Y-m-d");        }        else        {            $err_msg = "表格第".$row."行时间格式错误,请修改后再导入";            break;        }    }    else    {        $err_msg = "表格第".$row."行时间格式错误,请修改后再导入";    }}if($err_msg){    echo $err_msg;    exit;}
0 0
原创粉丝点击