【PHP】匯入EXL

phpExcelReader 載點

使用方法：

require_once("phpExcelReader/reader.php"); $uploadExcel = $_FILES['fileToUpload']['tmp_name']; // 上傳的欄位 $data = new Spreadsheet_Excel_Reader(); $data->setOutputEncoding('UTF-8'); $data->read($uploadExcel); $readData =array(); //讀取檔案中的每一格，並把它存至陣列 for ($i = 2; $i <= $data->sheets[0]['numRows']; $i++ ) { for ($j = 1; $j <= $data->sheets[0]['numCols']; $j++ ) { $readData[$i][$j] = $data->sheets[0]['cells'][$i][$j]; } } // 以下自行處理 print_r($readData);
PHPExcel：
require_once("PHPExcel.php"); header("Content-Type:text/html; charset=utf-8"); $file = $_FILES['shopee_import']['tmp_name']; try { $objPHPExcel = PHPExcel_IOFactory::load($file); } catch(Exception $e) { die('Error loading file "'.pathinfo($file,PATHINFO_BASENAME).'": '.$e->getMessage()); } $sheetData = $objPHPExcel->getActiveSheet()->toArray(null,true,true,true);