浏览器下载模板excel是怎么做的，这篇文章告诉你

前言

我们在开发一些后台系统时&＃xff0c;可能会遇到下载模板excel的功能&＃xff0c;用户点击下载模板&＃xff0c;即下载一个模板excel到本地&＃xff0c;这个功能是怎么实现的呢&＃xff1f;下面就告诉你

实现

先放一个模板excel到static或者templates文件夹下

下面就是实现的代码

public void downTemplateExcel(HttpServletRequest request, HttpServletResponse response) throws IOException {String fileName&＃61;"模板.xlsx";FileInputStream inputStream&＃61;null;ServletOutputStream outputStream &＃61; null;//获取文件路径String filePath &＃61; getClass().getResource("/static/" &＃43; fileName).getPath();//设置响应头response.setContentType("");response.setCharacterEncoding("UTF-8");//获得浏览器代理信息final String userAgent &＃61; request.getHeader("USER-AGENT");//判断浏览器代理并分别设置响应给浏览器的编码格式String finalFileName &＃61; null;if(StringUtils.contains(userAgent, "MSIE")||StringUtils.contains(userAgent,"Trident")){//IE浏览器finalFileName &＃61; URLEncoder.encode(fileName,"UTF8");System.out.println("IE浏览器");}else if(StringUtils.contains(userAgent, "Mozilla")){//google,火狐浏览器finalFileName &＃61; new String(fileName.getBytes(), "ISO8859-1");}else{finalFileName &＃61; URLEncoder.encode(fileName,"UTF8");//其他浏览器}filePath &＃61; URLDecoder.decode(filePath, "UTF-8");//设置HTTP响应头response.setHeader("Content-Disposition", "attachment;fileName&＃61;" &＃43; finalFileName);try {
// 获取输入流inputStream &＃61; new FileInputStream(filePath);
// 获取输出流outputStream&＃61;response.getOutputStream();int len &＃61; 0;byte[] buffer &＃61; new byte[1024];while ((len &＃61; inputStream.read(buffer)) >0) {
// 将文件写到输出流outputStream.write(buffer,0,len);}}catch (Exception e){e.printStackTrace();}finally {if (outputStream!&＃61;null){outputStream.flush();outputStream.close();}if (inputStream!&＃61;null){inputStream.close();}}}