Thinkphp + PHPOffice的导出方法

use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\Writer\Xlsx;

public function export(){
	// 创建Excel对象
	$spreadsheet = new Spreadsheet();
	$sheet = $spreadsheet->getActiveSheet();

	// 设置表头
	$sheet->setCellValue('A1', '姓名');
	$sheet->setCellValue('B1', '年龄');
	$sheet->setCellValue('C1', '性别');

	// 填充数据
	$data = [
		['张三', 20, '男'],
		['李四', 25, '女'],
		['王五', 30, '男'],
	];
	foreach ($data as $key => $value) {
		$row = $key + 2;
		$sheet->setCellValue('A' . $row, $value[0]);
		$sheet->setCellValue('B' . $row, $value[1]);
		$sheet->setCellValue('C' . $row, $value[2]);
	}

	// 导出Excel文件
	$filename = 'test.xlsx';
	header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
	header('Content-Disposition: attachment;filename="' . $filename . '"');
	header('Cache-Control: max-age=0');
	$writer = new Xlsx($spreadsheet);
	$writer->save('php://output');
	exit();
}