php匯入excel php使用phpexcel匯入excel檔案

//載入PHPExcel類 include(dirname(__FILE__).'/phpexcel/PHPExcel.php'); $Obj = new PHPExcel_Reader_Excel5(); $Obj->setReadDataOnly(true); //讀取demo.xls檔案 $phpExcel = $Obj->load(dirname(__FILE__).'/output.xls'); //擷取當前活動sheet $objWorksheet = $phpExcel->getActiveSheet(); //擷取行數 $highestRow = $objWorksheet->getHighestRow(); //擷取列數 //by bbs.it-home.org $highestColumn = $objWorksheet->getHighestColumn(); $highestColumnIndex = PHPExcel_Cell::columnIndexFromString($highestColumn); //迴圈輸出資料 $data = array(); for($row = 1; $row <= $highestRow; ++$row) { for($col = 0; $col < $highestColumnIndex; ++$col) { $val = $objWorksheet->getCellByColumnAndRow($col, $row)->getValue(); $data[$row][$col] = trim($val); } } echo ' '; print_r($data); echo ' '; 複製代碼

