JAVA 导出本地项目Excel模板
模板位置
实现代码
@ApiOperation("模板下载API")
@PostMapping("/importTemplate")
public void exportExcel(HttpServletResponse response){
String filePath = "./templates/BOM.xlsx";
OutputStream out = null;
InputStream in = null;
XSSFWorkbook workbook = null;
try {
out = response.getOutputStream();
in = new BufferedInputStream(new ClassPathResource(filePath).getInputStream());
String type = new MimetypesFileTypeMap().getContentType("BOM.xlsx");
response.setContentType(type);
String name = URLEncoder.encode("物料信息导入模板.xlsx", "UTF-8");
response.setHeader("Content-Disposition", "attachment;filename=" + name);
workbook = new XSSFWorkbook(in);
workbook.write(out);
} catch (Exception e) {
e.printStackTrace();
}finally {
IoUtil.close(workbook);
IoUtil.close(out);
IoUtil.close(in);
}
}