#樣式鏈接 https://blog.csdn.net/gc258_2767_qq/article/details/81003656 ~~~ public function daochu() { set_time_limit(0); $data = $this->model->getList($this->request->param()); $spreadsheet = new Spreadsheet(); /* 設置默認文字居中 */ $styleArray = [ 'alignment' => [ 'horizontal' => 'center', 'vertical' => 'center', ], ]; $spreadsheet->getDefaultStyle()->applyFromArray($styleArray); $spreadsheet->getActiveSheet()->getRowDimension(1)->setRowHeight(30); $spreadsheet->getActiveSheet()->getDefaultRowDimension()->setRowHeight(20); $spreadsheet->getActiveSheet()->getColumnDimension('A')->setWidth(20); $spreadsheet->getActiveSheet()->getColumnDimension('B')->setWidth(30); $spreadsheet->getActiveSheet()->getColumnDimension('C')->setWidth(50); $spreadsheet->getActiveSheet()->getStyle('A')->getFont()->getColor()->setARGB('FFFF0000'); $spreadsheet->getActiveSheet()->getStyle('A1')->getFont()->getColor()->setARGB('FF000000'); $sheet = $spreadsheet->getActiveSheet(); $sheet->setCellValue('A1', 'id編號'); $sheet->setCellValue('B1', '訂單編號'); $sheet->setCellValue('C1', '創建時間'); /*--------------開始從數據庫提取信息插入Excel表中------------------*/ //$i=2; //定義一個i變量，目的是在循環輸出數據是控制行數 /*$i = 2,因為第一行是表頭，所以寫到表格時候只能從第二行開始寫。*/ $count = count($data); //計算有多少條數據 for ($i = 2; $i <= $count+1; $i++) { $sheet->setCellValue('A' . $i, $data[$i-2]['id']); $sheet->setCellValue('B' . $i, $data[$i-2]['order_no']); $sheet->setCellValue('C' . $i, $data[$i-2]['create_time']); } header('Content-Type: application/vnd.ms-excel'); header('Content-Disposition: attachment;filename="'.'訂單信息'.'.xlsx"'); header('Cache-Control: max-age=0');//禁止緩存 header('Cache-Control: must-revalidate, post-check=0, pre-check=0'); header("Expires: 0"); ob_clean(); ob_start(); $writer = new Xlsx($spreadsheet); $writer->save('php://output'); // 清除數據 $spreadsheet->disconnectWorksheets(); unset($spreadsheet); ob_flush(); flush();//必須同時使用 ob_flush() 和flush() 函數來刷新輸出緩沖。 exit; } ~~~