## 簡介 Excel導入導出都需要它不多說 ## 環境要求 ~~~ InitAdmin >= 201903 PHP >= 5.6 PHP extension php_zip enabled PHP extension php_xml enabled PHP extension php_gd2 enabled ~~~ ## 安裝擴展 ``` cd actionphp/vendor composer require phpoffice/phpspreadsheet ``` ## 基本用法 ``` $spreadsheet = new \PhpOffice\PhpSpreadsheet\Spreadsheet(); $sheet = $spreadsheet->getActiveSheet(); $sheet->setCellValue('A1', 'Hello World !'); $writer = new \PhpOffice\PhpSpreadsheet\Writer\Xlsx($spreadsheet); $writer->save('hello world.xlsx'); ``` ## 英文文檔地址 https://phpspreadsheet.readthedocs.io/en/latest/