/**
* 导出全部用户的Excel表格
*/
public function daochuexcle(){
$arrays_list= (
[0] => Array
(
[user_id] => 19
[user_knapsack_id] => 232
[grade] => 2
[type] => card
[upgrade_gc] => 100
[desc] =>
[upgrade_time] => 1642834756
)
[1] => Array
(
[user_id] => 19
[user_knapsack_id] => 232
[grade] => 3
[type] => card
[upgrade_gc] => 2
[desc] =>
[upgrade_time] => 1642834772
)
[2] => Array
(
[user_id] => 17
[user_knapsack_id] => 232
[grade] => 3
[type] => card
[upgrade_gc] => 50
[desc] =>
[upgrade_time] => 1642834772
)
)
// print_r($arrays_list);
$spreadsheet = new Spreadsheet();
# 获取活动工作薄
$sheet = $spreadsheet->getActiveSheet();
// 批量赋值
$sheet->setCellValue('A1','ID');
$sheet->setCellValue('B1','用户背包ID');
$sheet->setCellValue('C1','用户等级');
$sheet->setCellValue('D1','类型');
$sheet->setCellValue('E1','用户可用积分');
$sheet->setCellValue('F1','会员级别');
$sheet->setCellValue('G1','xxxx');
$sheet->setCellValue('H1','时间');
//$sheet->fromArray(
$arrays_list,
3,
'A2'
);
# Xlsx类 将电子表格保存到文件
$writer = new Xlsx($spreadsheet);
$writer->save('1.xlsx');
// 客户端文件下载
header('Content-Type:application/vnd.ms-excel');
header('Content-Disposition:attachment;filename=1.xls');
header('Cache-Control:max-age=0');
$writer = \PhpOffice\PhpSpreadsheet\IOFactory::createWriter($spreadsheet, 'Xls');
$writer->save('php://output');
return $this->renderSuccess('','完成');
}