/**
* 手机号模版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
【后端实现文件下载】文件下下来但是打开有问题,,待整理 要死了
推荐阅读
- Java|Java基础——数组
- 人工智能|干货!人体姿态估计与运动预测
- java简介|Java是什么(Java能用来干什么?)
- Java|规范的打印日志
- Linux|109 个实用 shell 脚本
- 程序员|【高级Java架构师系统学习】毕业一年萌新的Java大厂面经,最新整理
- Spring注解驱动第十讲--@Autowired使用
- SqlServer|sql server的UPDLOCK、HOLDLOCK试验
- jvm|【JVM】JVM08(java内存模型解析[JMM])
- 技术|为参加2021年蓝桥杯Java软件开发大学B组细心整理常见基础知识、搜索和常用算法解析例题(持续更新...)