项目中实际用到的excel文件模板下载(包含文件名乱码问题),记录一下:
public void download(HttpServletResponse response) throws Exception{
String fileName = "xxx.xlsx";
String path = request.getSession().getServletContext().getRealPath("/WEB-INF/download/excelTemplate")+File.separator+fileName;
try {
// path是指欲下载的文件的路径。
File file = new File(path);
// 以流的形式下载文件。
InputStream fis = new BufferedInputStream(new FileInputStream(path));
byte[] buffer = new byte[fis.available()];
fis.read(buffer);
fis.close();
// 清空response
response.reset();
// 文件名转码
fileName = getBrowser(request, fileName);
// 设置response的Header
response.addHeader("Content-Disposition", "attachment;filename=" + new String(fileName.getBytes()));
response.addHeader("Content-Length", "" + file.length());
OutputStream toClient = new BufferedOutputStream(response.getOutputStream());
response.setContentType("application/octet-stream");
toClient.write(buffer);
toClient.flush();
toClient.close();
} catch (IOException ex) {
ex.printStackTrace();
}
}
private String getBrowser (HttpServletRequest request, String fileName) throws UnsupportedEncodingException {
//获取浏览器名(IE/Chrome/firefox)
String userAgent = request.getHeader("User-Agent");
if (userAgent.contains("Firefox")) {
fileName = new String(fileName.getBytes("UTF-8"), "ISO8859-1");
} else if (userAgent.contains("MSIE") || userAgent.contains("Trident")) {
fileName = URLEncoder.encode(fileName, "UTF-8");
} else if (userAgent.contains("Chrome")) {
fileName = new String(fileName.getBytes("UTF-8"), "ISO8859-1");
}
return fileName;
}