參考網站 https://www.itread01.com/content/1546366076.html 1.安裝Composer https://getcomposer.org/doc/00-intro.md#installation-windows 下載後執行,要選擇當前使用的php.exe所在位置 安裝完後重啟php、重啟command 2.安裝 在command前往php.exe所在位置 輸入 composer require phpoffice/phpspreadsheet 執行 3.測試 重啟php 用下面文字建立一個php檔案,放到網頁伺服器底下 <?php //這行要改成php底下vendor的絕對路徑 require '/vendor/autoload.php'; //寫入範例 use PhpOffice\PhpSpreadsheet\Spreadsheet; use PhpOffice\PhpSpreadsheet\Writer\Xlsx; $spreadsheet = new Spreadsheet(); $sheet = $spreadsheet->getActiveSheet(); $sheet->setCellValue('A1', '這是第一格'); $writer = new Xlsx($spreadsheet); $writer->save('aaa.xlsx'); //讀取範例 $reader = new \PhpOffice\PhpSpreadsheet\Reader\Xlsx(); try { //路徑隨需要更改 $spreadsheet = $reader->load('./excel/0001.xlsx'); } catch (\PhpOffice\PhpSpreadsheet\Reader\Exception $e) { die($e->getMessage()); } $sheet = $spreadsheet->getActiveSheet(); $res = array(); ...