``` composer require phpoffice/phpexcel ``` ``` use PHPExcel_IOFactory; use PHPExcel; //會員資料導出 public function excel(){ $PHPExcel = new PHPExcel();//實例化 for($i=1;$i<=3;$i++){ $PHPSheet = $PHPExcel->getActiveSheet(); $PHPSheet->setTitle("demo"); //給當前活動sheet設置名稱 $data=Db::table('user')->select(); $PHPSheet->setCellValue("A1","用戶id")->setCellValue("B1","賬號")->setCellValue("C1","openId")->setCellValue("D1","狀態")->setCellValue("E1","注冊時間");//表格數據 $i==2; foreach($data as $key=>$val){ $PHPSheet->setCellValue("A".$i,$val['user_id'])->setCellValue("B".$i,$val['account'])->setCellValue("C".$i,$val['openid'])->setCellValue("D".$i,$val['sys_status'])->setCellValue("E".$i,$val['create_time']);//表格數據 $i++; } } ob_end_clean(); header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet'); header('Content-Disposition: attachment;filename="會員.xls" '); header('Cache-Control: max-age=1'); header("Content-type: text/html; charset=utf-8"); $PHPWriter = PHPExcel_IOFactory::createWriter($PHPExcel,"Excel2007");//創建生成的格式 $PHPWriter->save("php://output"); //表示輸出到瀏覽器 } ```