admin管理员组

文章数量:1516870

使用poi,做传统的excel导出,然后想在浏览器中,让用户选择另存为,保存用户下载的xls文件,这个时候,可能的是在ie下出现乱码(ie,9,10,11),但在firefox,chrome下没乱码,

因此必须综合判断,编写一个工具类:

response.setHeader("Cache-Control", "private");  
		response.setHeader("Pragma", "private"); 
		response.setContentType("application/vnd.ms-excel;charset=UTF-8");
		response.setHeader("Content-Type", "application/force-download"); 
		filename = ExcelNameEncode.encodeFilename(filename, request);// 处理中文文件名
		response.setHeader("Content-disposition", "attachment;filename="
				+ filename);
public static String encodeFilename(String filename,
			HttpServletRequest request) {
		/**
		 * 获取客户端浏览器和操作系统信息 在IE浏览器中得到的是:User-Agent=Mozilla/4.0 (compatible; MSIE
		 * 6.0; Windows NT 5.1; SV1; Maxthon; Alexa Toolbar)
		 * 在Firefox中得到的是:User-Agent=Mozilla/5.0 (Windows; U; Windows NT 5.1;
		 * zh-CN; rv:1.7.10) Gecko/20050717 Firefox/1.0.6
		 */
		String agent = request.getHeader("USER-AGENT");
		try {
			if(agent != null){
				if (agent.indexOf("MSIE") != -1 || agent.indexOf("Trident") != -1) {
					return URLEncoder.encode(filename, "UTF-8");
				} else if (agent.indexOf("Mozilla") != -1) {
					return MimeUtility.encodeText(filename, "UTF-8", "B");
				}
			}
			return filename;
		} catch (Exception ex) {
			return filename;
		}
	}

本文标签: 浏览器中找回丢失导出困境