天天看點

原生php+phpexcel導入excel(帶處理時間)

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;
}