1.引入依赖
<!-- https://mvnrepository.com/artifact/org.apache.poi/poi -->
<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi</artifactId>
<version>3.17</version>
</dependency>
<!-- https://mvnrepository.com/artifact/org.apache.poi/poi-ooxml -->
<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi-ooxml</artifactId>
<version>3.17</version>
</dependency>
注意依赖版本需一致,不然容易报错
2.模板路径
3.java代码
@GetMapping("dowloadTemplate")
public void dowloadTemplate(HttpServletResponse response) throws IOException {
//获取模板excel表
XSSFWorkbook inwb = new XSSFWorkbook(new FileInputStream(ResourceUtils.getFile("classpath:excelTemplate/userTemplate.xls")));
response.setContentType("application/vnd.ms-excel;charset=utf-8");
OutputStream out = response.getOutputStream();
response.setHeader("Content-disposition", "attachment;filename=userTemplate.xls");//默认Excel名称
inwb.write(out);
out.flush();
out.close();
}
4.页面代码
<body>
<form method="post" action="/" enctype="multipart/form-data">
<input type="file" name="file">
<button type="submit">提交</button>
</form>
<button id="button">下载模板</button>
</body>
<script>
$("#button").click(function(){
window.location.href = "/dowloadTemplate";
});
</script>
注意不要用ajax请求,用window.location.href;