@RequestMapping(value = "download", method = RequestMethod.GET)
public void downloadExcel(HttpServletResponse response, HttpServletRequest request) {
try {
//本地项目中的模板
InputStream inStream =
Thread.currentThread().getContextClassLoader().getResourceAsStream("templates" +
"/制度模板.xlsx");
//新模板名称
String name = "制度模板";
//IE下载文件存在文件名称乱码
// String name = "制度模板.xlsx";
// String userAgent = request.getHeader("User-Agent");
// response.reset();
// response.setCharacterEncoding("UTF-8");
// response.setHeader("Content-Disposition",
// "attachment; filename=" + new String(name.getBytes(), "ISO8859-1"));
// response.addHeader("Content-type", " multlpart/form-data");
response.setContentType("application/octet-stream");
response.addHeader("Content-Disposition",
"attachment; filename=" + getFileName(request, name) + ".xlsx");
response.addHeader("Content-type", " multlpart/form-data");
// 循环取出流中的数据
byte[] b = new byte[2048];
int len;
while ((len = inStream.read(b)) > 0) {
response.getOutputStream().write(b, 0, len);
}
inStream.close();
} catch (Exception e) {
e.printStackTrace();
}
}
/**
* 区分ie 和其他浏览器的下载文件乱码问题
*
* @param request
* @param fileName
* @return
*/
public String getFileName(HttpServletRequest req, String fileName) {
String userAgent = req.getHeader("user-agent");
userAgent = userAgent == null ? "" : userAgent.toLowerCase();
String name = fileName;
try {
//针对IE或者以IE为内核的浏览器:
if (userAgent.contains("msie") || userAgent.contains("trident")) {
name = URLEncoder.encode(name, "UTF-8");
} else {
name = new String(name.getBytes(), "iso-8859-1");
}
} catch (Exception e) {
e.printStackTrace();
}
return name;
}
@大神们 欢迎大家探讨交流