/**
* 下载Excel
*
* @param response 请求response
*/
@RequestMapping({"/template/download"})
public static void downExcel(HttpServletResponse response) {
InputStream fileInputStream = null;
InputStream fis = null;
OutputStream outputStream = null;
String fileName = "科学数据平台数据集.xlsx";
try {
// 将文件写入输入流
//主要ClassPathResource是获取类路径下的文件
fileInputStream = (new ClassPathResource("templates/" + fileName)).getInputStream();
fis = new BufferedInputStream(fileInputStream);
byte[] buffer = new byte[fis.available()];
fis.read(buffer);
fis.close();
// 清空response
response.reset();
// 设置response的Header
// 解决跨域问题,这句话是关键,对任意的域都可以,如果需要安全,可以设置成安前的域名
response.addHeader("Access-Control-Allow-Origin", "*");
response.addHeader("Access-Control-Allow-Methods", "GET, POST, PUT, DELETE");
response.setHeader("FileName", URLEncoder.encode(fileName, "UTF-8"));
response.setHeader("Access-Control-Expose-Headers", "FileName");
response.setCharacterEncoding("UTF-8");
//Content-Disposition的作用:告知浏览器以何种方式显示响应返回的文件,用浏览器打开还是以附件的形式下载到本地保存
//attachment表示以附件方式下载 inline表示在线打开 "Content-Disposition: inline; filename=文件名.mp3"
// filename表示文件的默认名称,因为网络传输只支持URL编码的相关支付,因此需要将文件名URL编码后进行传输,前端收到后需要反编码才能获取到真正的名称
response.addHeader("Content-Disposition", "attachment;filename=" + URLEncoder.encode(fileName, "UTF-8"));
// 告知浏览器文件的大小
// response.addHeader("Content-Length", "" + fileInputStream.length());
outputStream = new BufferedOutputStream(response.getOutputStream());
response.setContentType("application/octet-stream");
outputStream.write(buffer);
outputStream.flush();
} catch (IOException e) {
e.printStackTrace();
ActionResult.fail("文件下载异常");
} finally {
if (fileInputStream != null) {
try {
fileInputStream.close();
} catch (IOException e) {
e.printStackTrace();
}
}
if (fis != null) {
try {
fis.close();
} catch (IOException e) {
e.printStackTrace();
}
}
if (outputStream != null) {
try {
outputStream.close();
} catch (IOException e) {
e.printStackTrace();
}
}
}
}
大题结构如图所示
即可完成模板下载!!!