$PHPExcel = new PHPExcel();
/**默认用excel2007读取excel,若格式不对,则用之前的版本进行读取*/
$PHPReader = new PHPExcel_Reader_Excel2007();
if (!$PHPReader->canRead($filePath)) {
$PHPReader = new PHPExcel_Reader_Excel5();
if (!$PHPReader->canRead($filePath)) {
echo 'no Excel';
return;
}
}
$PHPExcel = $PHPReader->load($filePath);
$currentSheet = $PHPExcel->getSheet(0); /* * 读取excel文件中的第一个工作表 */
$allColumn = $currentSheet->getHighestColumn();/**取得最大的列号*/
$allRow = $currentSheet->getHighestRow(); /* * 取得一共有多少行 */
PHPExcel_Cell::columnIndexFromString(); //字母列转换为数字列 如:AA变为27
for ($currentRow = 2; $currentRow <= $allRow; $currentRow = $currentRow + 2) {
$pair_name = $currentSheet->getCellByColumnAndRow(0, $currentRow)->getValue();
$trailtime = $currentSheet->getCellByColumnAndRow(3, $currentRow)->getValue();
$trailtime = date("Y-m-d H:i:s", PHPExcel_Shared_Date::ExcelToPHP($trailtime) - 28800); //时间的转换
}
PHP导入excel
最新推荐文章于 2017-12-12 10:15:11 发布