/**
* 手机号模版Excel文件下载
*/
@GetMapping("/一个映射路径")
public boolean excelTplDownload(HttpServletResponse response)
throws IOException {
String realName = "text.xls";
ResourcePatternResolver resolver = new PathMatchingResourcePatternResolver();
Resource resource= resolver.getResource("/tpl-xlsx/" + realName);
String fileName = realName;
response.reset();
if (resource.exists()) {
response.setContentType("application/vnd.ms-excel;charset=utf-8");
// response.setContentType("application/vnd.ms-excel"); //"application/vnd.ms-excel;charset=utf-8" application/force-download
response.addHeader("Content-Disposition","attachment;fileName=" + new String(fileName.getBytes("UTF-8"),"iso-8859-1"));
byte[] buffer = new byte[1024];
InputStream fis = null;
BufferedInputStream bis = null;
fis = resource.getInputStream();
response.setContentLength(fis.available());
try {
bis = new BufferedInputStream(fis);
BufferedOutputStream os = new BufferedOutputStream(response.getOutputStream());
int i = 0;
while ((i = fis.read(buffer))!= -1) {
os.write(buffer, 0, i);
}
log.info("下载成功fileName={}", fileName);
os.flush();
} catch (Exception e) {
e.printStackTrace();
} finally {
if (bis != null)
{
bis.close();
}
if (fis != null)
{
fis.close();
}
}
}
return true;
}
@GetMapping("/一个映射路径")
先写的 PostMapping 一直报错405
文件下下来但是打开有问题,,待整理 要死了