@RestController
public class StudentController {
@RequestMapping("/download")
public JsonResult download(HttpServletResponse response) throws IOException {
//文件名需要这样写,不能在setHeader直接写中文名,否则下载的文件名字为空,只有后缀
String fileName = new String("学生表.xlsx".getBytes(), StandardCharsets.ISO_8859_1);
response.setContentType("application/vnd.ms-excel");
response.setCharacterEncoding("utf8");
response.setHeader("Content-disposition", "attachment;filename=" + fileName );
EasyExcel.write(response.getOutputStream(), Student.class)
.sheet("sheet")
.doWrite(getStudentList());
return new JsonResult().setCode(1).setMessage("下载成功!").setData(null);
}
private List getStudentList() {
ArrayList<Student> students = new ArrayList<>();
for (int i = 0; i < 1000; i++) {
Student student = new Student(i, "名字" + i, i, new Date());
students.add(student);
}
return students;
}
}
困扰我了一会,特此记录,以备之需。