原生php+phpexcel导入excel(带处理时间)

最新推荐文章于 2024-06-29 09:51:21 发布

czlearnunity3d

最新推荐文章于 2024-06-29 09:51:21 发布

阅读量1.4k

点赞数

分类专栏： php 文章标签： php phpexcel

本文链接：https://blog.csdn.net/czlearnunity3d/article/details/87939473

版权

php 专栏收录该内容

13 篇文章 0 订阅

订阅专栏

function excelToArray2($file){
    require_once dirname(__FILE__) . '/PHPExcel/IOFactory.php';
    require_once dirname(__FILE__) . '/PHPExcel/Shared/Date.php';
    
    //加载excel文件
    $filename = $file;
    $objPHPExcelReader = PHPExcel_IOFactory::load($filename);  
 
    $sheet = $objPHPExcelReader->getSheet(0);       // 读取第一个工作表(编号从 0 开始)
    $highestRow = $sheet->getHighestRow();          // 取得总行数
    $highestColumn = $sheet->getHighestColumn();    // 取得总列数
 
    $arr = array('A','B','C','D','E','F','G','H','I','J','K','L','M', 'N','O','P','Q','R','S','T','U','V','W','X','Y','Z');
    // 一次读取一列
    $res_arr = array();
    for ($row = 2; $row <= $highestRow; $row++) {
        $row_arr = array();
        for ($column = 0; $arr[$column] != 'T'; $column++) {
            if($column==0)
            {
                $val = gmdate("Y/m/d", PHPExcel_Shared_Date::ExcelToPHP($sheet->getCellByColumnAndRow($column, $row)->getValue()));
            }
            else if($column==15)
            {
                $val = gmdate("Y/m/d H:i:s", PHPExcel_Shared_Date::ExcelToPHP($sheet->getCellByColumnAndRow($column, $row)->getValue()));
            }
            else if($column==16)
            {
                $val = gmdate("Y/m/d H:i:s", PHPExcel_Shared_Date::ExcelToPHP($sheet->getCellByColumnAndRow($column, $row)->getValue()));
            }
            else
            {
                $val = $sheet->getCellByColumnAndRow($column, $row)->getValue();
            }
            
            $row_arr[] = $val;
        }
        
        $res_arr[] = $row_arr;
    }
    
    return $res_arr;
}