@GetMapping("/downLoadExcel")
public void downLoadExcel(HttpServletResponse response, String id) {
//数据集合
List<EduTeacher> list = eduTeacherDao.findById(id);
String fileName = "模板";
try {
Workbook workbook = new XSSFWorkbook(new ClassPathResource("templates/" + "导出模板.xlsx").getInputStream());
Sheet sheet = workbook.getSheet("sheet1");
for (int i = 0; i < list.size(); i++) {
Row row = sheet.createRow(i + 1);
Cell cell = row.createCell(0);
cell.setCellValue(list.get(i).getCareer());
Cell cell2 = row.createCell(1);
cell2.setCellValue(list.get(i).getAvatar());
}
ServletOutputStream outputStream = response.getOutputStream();
response.setContentType("application/msexcel");
response.reset();
response.setHeader("Content-disposition", "attachment;fileName=" + URLEncoder.encode(fileName + ".xlsx", "UTF-8"));
workbook.write(outputStream);
outputStream.flush();
outputStream.close();
} catch (IOException e) {
e.printStackTrace();
}
}
Excel模板导出
最新推荐文章于 2022-12-22 11:30:31 发布