JXLS 利用自定义Excel模板导出excl

最新推荐文章于 2025-07-03 14:46:49 发布

原创最新推荐文章于 2025-07-03 14:46:49 发布 · 1.9k 阅读

0 ·

CC 4.0 BY-SA版权

后台框架专栏收录该内容

11 篇文章

订阅专栏

本文介绍如何利用jxls库处理Excel模板，包括依赖配置、数据填充及文件导出过程。通过实例展示了如何将数据集填充到Excel模板，并正确设置响应头以支持不同浏览器的下载。

mavn 依赖

</dependency>

<artifactId>jxls-reader</artifactId>

</dependency>

</dependency>

</dependency>

<artifactId>jxls-jexcel</artifactId>

</dependency>

Excel 模板例子:

          List<ReportWorksheet> list = new ArrayList<ReportWorksheet>();
          reportWorksheetList.drainTo(list);
           // 定义一个Map，往里面放入要在模板中显示数据
           Map<String, Object> model = new HashMap<String, Object>();
           model.put("reportWorksheetList", list);
           //调用之前写的工具类，传入模板路径，输出流，和装有数据Map
           //模板路径
               //String templateFileName=request.getSession().getServletContext().getRealPath("WEB-INF")+File.separator+"classes"+File.separator+"templates"+File.separator+"modules"+File.separator+"gen"+File.separator+"colleges.xls";
           String templateFileName=request.getSession().getServletContext().getRealPath("WEB-INF")+File.separator+"reportlets"+File.separator+"worksheetDetailReportTemplates"+File.separator+"exportHoBySevenDays.xls";
               XLSTransformer transformer = new XLSTransformer();
               try{
                   transformer.transformXLS(templateFileName, model, fileName);
                   //输入
                   BufferedInputStream bis = new BufferedInputStream(new FileInputStream(new File(fileName)));
                   //输出
                   BufferedOutputStream bos = new BufferedOutputStream(response.getOutputStream());

                   try {
                       // 中文文件名支持
                       String encodedfileName = null;
                       String agent = request.getHeader("USER-AGENT");

                       if (null != agent && -1 != agent.indexOf("MSIE")) {// IE
                           encodedfileName = java.net.URLEncoder.encode(fileName, "UTF-8");
                       } else if (null != agent && -1 != agent.indexOf("Mozilla")) {
                           encodedfileName = new String(fileName.getBytes("UTF-8"),"iso-8859-1");
                       } else {
                           encodedfileName = java.net.URLEncoder.encode(fileName, "UTF-8");
                       }
                       response.setHeader("Content-Disposition", "attachment; filename=\""
                               + encodedfileName + "\"");
                   } catch (UnsupportedEncodingException e) {
                       e.printStackTrace();
                   }

                   int byteRead = 0;
                   byte[] buffer = new byte[8192];
                   while ((byteRead = bis.read(buffer, 0, 8192)) != -1) {
                       bos.write(buffer, 0, byteRead);
                   }
                   bis.close();
                   bos.flush();
                   bos.close();
               }catch (Exception e) {
                   e.printStackTrace();
               }

导出结果：