>[danger] phpspreadsheet ``` composer require phpoffice/phpspreadsheet ``` [https://packagist.org/packages/phpoffice/phpspreadsheet](https://packagist.org/packages/phpoffice/phpspreadsheet) >[danger] 在安裝前先查看當前環境 fileinfo 擴展有沒有開啟 如果沒有開啟`fileinfo`擴展安裝該擴展庫會報錯 >[danger] 導出Excel表格封裝 ```php use PhpOffice\PhpSpreadsheet\IOFactory; use PhpOffice\PhpSpreadsheet\Spreadsheet; ``` ```php /** * 導出Excel表格 Xlsx格式(2007版) * * @author liang <23426945@qq.com> * @datetime 2019-12-22 * * @param array $title 表頭單元格內容 * @param array $data 從第二行開始寫入的數據 * @param string $path Excel文件保存位置,路徑中的目錄必須存在 * * @return null 沒有設定返回值 */ private function excel($title = [], $data = [], $path = '') { // 獲取Spreadsheet對象 $spreadsheet = new Spreadsheet(); $sheet = $spreadsheet->getActiveSheet(); // 表頭單元格內容 第一行 $titCol = 'A'; foreach ($title as $value) { // 單元格內容寫入 $sheet->setCellValue($titCol . '1', $value); $titCol++; } // 從第二行開始寫入數據 $row = 2; foreach ($data as $item) { $dataCol = 'A'; foreach ($item as $value) { // 單元格內容寫入 $sheet->setCellValue($dataCol . $row, $value); $dataCol++; } $row++; } $writer = IOFactory::createWriter($spreadsheet, 'Xlsx'); $result = $writer->save($path . '.xlsx'); } ``` >[danger] 調用示例 ``` $data = Db::table('ay_config')->select(); $title = ['id', '字段名', 'value值', '類型', '排序', '描述']; $this->excel($title, $data, $filename = './excel/03'); ```