- 前言
- 一、依赖
- 二、代码
前言
项目中上传文件导入excel数据时,往往需要excel模板,提供给用户下载。
一、依赖
org.apache.poi
poi
3.9
org.apache.poi
poi-ooxml
3.9
二、代码
excel模板路径:
代码如下:
@GetMapping("/download")
public void templateDownload(HttpServletResponse response) {
String fileName = "template.xls";
InputStream fis = null;
ServletOutputStream out = null;
try {
fis = Thread.currentThread().getContextClassLoader().getResourceAsStream("template/"+fileName);
//HSSFWorkbook:是操作Excel2003以前(包括2003)的版本,扩展名是.xls
//XSSFWorkbook:是操作Excel2007的版本,扩展名是.xlsx
HSSFWorkbook workbook = new HSSFWorkbook(fis);
response.setContentType("application/binary;charset=ISO8859-1");
response.setHeader("Content-disposition", "attachment; filename=" + fileName);
out = response.getOutputStream();
workbook.write(out);
} catch (IOException e) {
e.printStackTrace();
} finally {
//关闭流
try {
if(out!=null){
out.close();
}
if(fis!=null){
fis.close();
}
} catch (IOException e) {
e.printStackTrace();
}
}
}



