ThinkPhP5使用phpexcle 導出數據（復制粘貼就可使用） · 個人博客

? ## 導入擴展： ~~~ 安裝命令：composer require phpoffice/phpexcel ~~~ ## 核心代碼： ~~~php /*導出*/ public function exports() { $adminList = Orders::all(); /*TODO 這個條件需要處理*/ $newExcel = new Spreadsheet(); //創建一個新的excel文檔 $objSheet = $newExcel->getActiveSheet(); //獲取當前操作sheet的對象 //設置寬度為true,不然太窄了 $newExcel->getActiveSheet()->getColumnDimension('A')->setAutoSize(true); $newExcel->getActiveSheet()->getColumnDimension('B')->setAutoSize(true); //設置第一欄的標題 $objSheet ->setCellValue('A1', '訂單號') ->setCellValue('B1', '金額'); foreach ($adminList as $k => $val) { $k = $k + 2; $objSheet ->setCellValue('A' . $k, $val['order_sn']) ->setCellValue('B' . $k, $val['total_amount']); } $this->downloadExcel($newExcel, date('YmsHis', time()) . time(), 'Xls'); } //公共文件，用來傳入xls并下載 public function downloadExcel($newExcel, $filename, $format) { if ($format == 'Xlsx') { header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet'); } elseif ($format == 'Xls') { header('Content-Type: application/vnd.ms-excel'); } header("Content-Disposition: attachment;filename=" . $filename . date('Y-m-d') . '.' . strtolower($format)); header('Cache-Control: max-age=0'); $objWriter = IOFactory::createWriter($newExcel, $format); $objWriter->save('php://output'); exit; } ~~~ ?