devbox
代码吟游诗人
这个屌丝很懒，什么也没留下！
关注作者
热门标签
热门文章
当前位置:   article > 正文

按照模板生成文件，Word 或者 Excel

作者：代码吟游诗人 | 2024-02-02 11:14:34

赞

踩

按照模板生成文件，Word 或者 Excel

需求流程：

    

模板部分如图：

Web端技术选用Jfinal

功能实现：

下面代码是调用 --“外部接口”--传参，将前端选中的信息传给后端， 另外将后端返回的文件流下载成文件

  1. package ibasic.web.com.controller;
  2.  
  3. import java.io.BufferedInputStream;
  4. import java.io.BufferedOutputStream;
  5. import java.io.BufferedReader;
  6. import java.io.ByteArrayOutputStream;
  7. import java.io.File;
  8. import java.io.FileInputStream;
  9. import java.io.FileOutputStream;
  10. import java.io.IOException;
  11. import java.io.InputStream;
  12. import java.io.InputStreamReader;
  13. import java.io.OutputStream;
  14. import java.net.URLDecoder;
  15. import java.text.SimpleDateFormat;
  16. import java.util.Date;
  17.  
  18. import javax.servlet.annotation.MultipartConfig;
  19. import javax.servlet.annotation.WebServlet;
  20. import javax.servlet.http.HttpServlet;
  21. import javax.servlet.http.HttpServletRequest;
  22. import javax.servlet.http.HttpServletResponse;
  23.  
  24. import org.apache.http.HttpResponse;
  25. import org.apache.http.HttpStatus;
  26. import org.apache.http.client.HttpClient;
  27. import org.apache.http.client.config.RequestConfig;
  28. import org.apache.http.client.methods.HttpPost;
  29. import org.apache.http.entity.StringEntity;
  30. import org.apache.http.impl.client.HttpClientBuilder;
  31. import org.apache.http.message.BasicHeader;
  32. import org.apache.http.protocol.HTTP;
  33.  
  34. import com.jfinal.kit.PropKit;
  35.  
  36. import net.sf.json.JSONObject;
  37.  
  38. //excel模板
  39. @MultipartConfig
  40. @WebServlet("/templateExportServlet")
  41. public class TemplateExportServlet  extends HttpServlet{
  42. 	
  43. 	
  44.  
  45. 	@Override
  46. 	protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws IOException {
  47. //		String data = req.getParameter("data");
  48. 		BufferedReader header  = req.getReader();
  49. 		StringBuffer sb = new StringBuffer();
  50. 	    String str ="" ;
  51.         //将数据读到StringBuffer里面
  52. 	    while (null != (str = header.readLine())){
  53. 	        sb.append( str );
  54. 	    }
  55. //	    String params = sb.toString().replaceAll("%(?![0-9a-fA-F]{2})", "%25").replaceAll("\\+", "%2B");
  56. 	
  57. //	   String content =  URLDecoder.decode(params,"UTF-8");
  58. 		JSONObject jsonData = JSONObject.fromObject(sb.toString());
  59. 		String url = PropKit.get("template_url");
  60. 	
  61. 			RequestConfig config = RequestConfig.custom().setConnectTimeout(60000).setSocketTimeout(60000).build();
  62. 			HttpClient client = HttpClientBuilder.create().setDefaultRequestConfig(config).build();
  63. 	        HttpPost post = new HttpPost(url);
  64. 	        post.setHeader("Content-Type", "application/json");
  65. 	        String result = "";
  66. 	        
  67. 	        try {
  68. 	        
  69. 	            StringEntity s = new StringEntity(jsonData.toString(), "utf-8");
  70. 	            s.setContentEncoding(new BasicHeader(HTTP.CONTENT_TYPE, "application/json"));
  71. 	            post.setEntity(s);
  72. 	            HttpResponse httpResponse = client.execute(post);
  73. 	            InputStream inStream = httpResponse.getEntity().getContent();
  74. 	           
  75. 	           
  76. 	            
  77. 	            
  78. //	            BufferedReader reader = new BufferedReader(new InputStreamReader(inStream, "utf-8"));
  79. //	            StringBuilder strber = new StringBuilder();
  80. //	            String line = null;
  81. //	            while ((line = reader.readLine()) != null){
  82. //	                strber.append(line);
  83. //	            }
  84. //	            inStream.close();
  85. //	            result = strber.toString();
  86. //	            System.out.println(result);
  87. 	            if (HttpStatus.SC_OK != httpResponse.getStatusLine().getStatusCode()) {
  88. 	            	
  89. 	            	System.out.println("请求服务端失败"); 
  90. 	            } 
  91. 	       
  92. 	       
  93. //	        if(!"".equals(result)){
  94. 	        	 
  95. 	        	 String now = new SimpleDateFormat("yyyy-MM-dd HH-mm-ss").format(new Date());
  96. 	             String fileName = String.format("%s.xlsx", now);
  97. 	        	getFileByBytes(toByteArray(inStream), PropKit.get("excel_dir"),  fileName);
  98. 	        	download(PropKit.get("excel_dir")+fileName, resp);
  99. //	        }
  100. 	        	
  101. 	        } catch (Exception e) {
  102. 	        	
  103. 	        	e.printStackTrace();
  104. 	        }
  105. 	}
  106. 	
  107. 	public HttpServletResponse download(String path, HttpServletResponse response) {
  108.         try {
  109.             // path是指欲下载的文件的路径。
  110.             File file = new File(path);
  111.             // 取得文件名。
  112.             String filename = file.getName();
  113.             // 取得文件的后缀名。
  114.             String ext = filename.substring(filename.lastIndexOf(".") + 1).toUpperCase();
  115.  
  116.             // 以流的形式下载文件。
  117.             InputStream fis = new BufferedInputStream(new FileInputStream(path));
  118.             byte[] buffer = new byte[fis.available()];
  119.             fis.read(buffer);
  120.             fis.close();
  121.             // 清空response
  122.            // response.reset();
  123.             // 设置response的Header
  124.             response.addHeader("Content-Disposition", "attachment;filename=" + new String(filename.getBytes()));
  125.             response.addHeader("Content-Length", "" + file.length());
  126.             OutputStream toClient = new BufferedOutputStream(response.getOutputStream());
  127.             response.setContentType("application/octet-stream");
  128.             toClient.write(buffer);
  129.             toClient.flush();
  130.             toClient.close();
  131.         } catch (IOException ex) {
  132.             ex.printStackTrace();
  133.         }
  134.         return response;
  135.     }
  136. 	
  137. 	
  138. 	 /**
  139.      * 将Byte数组转换成文件
  140.      **/
  141.     public static void getFileByBytes(byte[] bytes, String filePath, String fileName) {
  142.         BufferedOutputStream bos = null;
  143.         FileOutputStream fos = null;
  144.         File file = null;
  145.         try {
  146.             File dir = new File(filePath);
  147.             // 判断文件目录是否存在
  148.             if (!dir.exists() && dir.isDirectory()) {
  149.                 dir.mkdirs();
  150.             }
  151.             file = new File(filePath + File.separator + fileName);
  152.             fos = new FileOutputStream(file);
  153.             bos = new BufferedOutputStream(fos);
  154.             bos.write(bytes);
  155.         } catch (Exception e) {
  156.             e.printStackTrace();
  157.         } finally {
  158.             if (bos != null) {
  159.                 try {
  160.                     bos.close();
  161.                 } catch (IOException e) {
  162.                     e.printStackTrace();
  163.                 }
  164.             }
  165.             if (fos != null) {
  166.                 try {
  167.                     fos.close();
  168.                 } catch (IOException e) {
  169.                     e.printStackTrace();
  170.                 }
  171.             }
  172.         }
  173.     }
  174.  
  175.     public static byte[] toByteArray(InputStream input) throws IOException {
  176.         ByteArrayOutputStream output = new ByteArrayOutputStream();
  177.         byte[] buffer = new byte[1024*4];
  178.         int n = 0;
  179.         while (-1 != (n = input.read(buffer))) {
  180.             output.write(buffer, 0, n);
  181.         }
  182.         return output.toByteArray();
  183.     }
  184. }

下面代码实现，接收参数，生成按照模板的文件， SpringBoot实现，将模板文件ftl 放在resource目录下即可。 最后 打成jar 。部署一个地方，将这个服务的ip:port/接口名 告知上面的web去调用即可

  1. package com.wenge.controller;
  2.  
  3. import com.alibaba.fastjson.JSONArray;
  4. import com.alibaba.fastjson.JSONObject;
  5. import com.wenge.model.Vo;
  6. import com.wenge.util.ExcelUtils;
  7. import org.springframework.beans.factory.annotation.Value;
  8. import org.springframework.core.io.FileSystemResource;
  9. import org.springframework.http.HttpHeaders;
  10. import org.springframework.http.MediaType;
  11. import org.springframework.http.ResponseEntity;
  12. import org.springframework.web.bind.annotation.PostMapping;
  13. import org.springframework.web.bind.annotation.RequestBody;
  14. import org.springframework.web.bind.annotation.RestController;
  15.  
  16. import java.io.ByteArrayOutputStream;
  17. import java.io.File;
  18. import java.io.FileInputStream;
  19. import java.text.SimpleDateFormat;
  20. import java.util.*;
  21.  
  22. /**
  23.  * @description:
  24.  * @author: hezha
  25.  */
  26. @RestController
  27. public class ExcelControll {
  28.     @Value("${excel.dir}")
  29.     private String dir_path ;
  30.  
  31.     @PostMapping("/downLoadExcel")
  32.     public  byte[] downLoadExcel(@RequestBody String data){
  33.         String msg = "";
  34.         Map<String, Object> dataMap = new HashMap<>();
  35.  
  36.         List<Vo> list = new ArrayList<>();
  37.  
  38.         try {
  39.             JSONObject json = JSONObject.parseObject(data);
  40.             if(json.containsKey("news")){
  41.                 JSONArray newsArr = json.getJSONArray("news");
  42.                 for (int i = 0; i < newsArr.size(); i++) {
  43.                     Vo vo = new Vo();
  44.                     JSONObject jsonObject = newsArr.getJSONObject(i);
  45.                     vo.setId(i+1);
  46.                     vo.setTitle(jsonObject.getString("title"));
  47.                     list.add(vo);
  48.                 }
  49.  
  50.             }
  51.  
  52.             dataMap.put("list", list);
  53.             String now = new SimpleDateFormat("yyyy-MM-dd HH-mm-ss").format(new Date());
  54.             String fileName = String.format("%s.xlsx", now);
  55.             System.out.println("当前导出的excel文件---->"+dir_path+fileName);
  56.             ExcelUtils.buildExcelByTemplate("templates/excel_template.xlsx", dir_path+fileName, dataMap);
  57. //            return dir_path+fileName;
  58.  
  59.             return getBytesByFile(dir_path+fileName);
  60.         } catch (Exception e) {
  61.             msg = "error";
  62.             e.printStackTrace();
  63.         }
  64. //        return msg;
  65.         return null;
  66.     }
  67.  
  68.  
  69.  
  70.     //将文件转换成Byte数组
  71.     public byte[] getBytesByFile(String pathStr) {
  72.         File file = new File(pathStr);
  73.         System.out.println("文件大小为: " + file.length());
  74.         try {
  75.             FileInputStream fis = new FileInputStream(file);
  76.             ByteArrayOutputStream bos = new ByteArrayOutputStream(1024);
  77.             byte[] b = new byte[1024];
  78.             int n;
  79.             while ((n = fis.read(b)) != -1) {
  80.                 bos.write(b, 0, n);
  81.             }
  82.             fis.close();
  83.             byte[] data = bos.toByteArray();
  84.             bos.close();
  85.             return data;
  86.         } catch (Exception e) {
  87.             e.printStackTrace();
  88.         }
  89.         return null;
  90.     }
  91.  
  92. }

 

  1. package com.wenge.controller;
  2.  
  3. import com.alibaba.fastjson.JSONArray;
  4. import com.alibaba.fastjson.JSONObject;
  5. import com.spire.doc.Document;
  6. import com.spire.doc.FileFormat;
  7. import com.spire.doc.Section;
  8. import com.spire.doc.collections.SectionCollection;
  9. import com.spire.doc.documents.HorizontalAlignment;
  10. import com.spire.doc.documents.Paragraph;
  11. import com.wenge.model.Vo;
  12.  
  13. import freemarker.template.Configuration;
  14. import freemarker.template.Template;
  15. import org.springframework.beans.factory.annotation.Value;
  16. import org.springframework.web.bind.annotation.PostMapping;
  17. import org.springframework.web.bind.annotation.RequestBody;
  18. import org.springframework.web.bind.annotation.RestController;
  19.  
  20. import java.io.*;
  21. import java.text.SimpleDateFormat;
  22. import java.util.*;
  23.  
  24. /**
  25.  * @description:
  26.  * @author: hezha
  27.  */
  28. @RestController
  29. public class WordController {
  30.     @Value("${word3.dir}")
  31.     private String dir_word3;
  32.  
  33.     @Value("${word1.dir}")
  34.     private String dir_word1;
  35.  
  36.     @PostMapping("/downLoadWord3")
  37.     public byte[] word3(@RequestBody String data){
  38.         String msg = "";
  39.         Map<String, Object> dataMap = new HashMap<>();
  40.         List<Vo> list = new ArrayList<>();
  41.  
  42.         try {
  43.             JSONObject json = JSONObject.parseObject(data);
  44.             if(json.containsKey("news")){
  45.                 JSONArray newsArr = json.getJSONArray("news");
  46.                 for (int i = 0; i < newsArr.size(); i++) {
  47.                     Vo vo = new Vo();
  48.                     JSONObject jsonObject = newsArr.getJSONObject(i);
  49.                     vo.setId(i+1);
  50.                     //（信源2，阅读数xx，评论量xx）
  51.                     String sitename = jsonObject.getString("source_name");
  52.                     String read_count = jsonObject.getString("read_count");
  53.                     String cmt_count  = jsonObject.getString("cmt_count");
  54.  
  55.                     vo.setDesc("("+sitename+"，阅读量"+read_count+"，评论量"+cmt_count+")");
  56.  
  57.                     vo.setPage_no("第"+jsonObject.getString("page_no")+"页");
  58.                     vo.setContent(jsonObject.getString("content"));
  59.                     list.add(vo);
  60.                 }
  61.  
  62.             }
  63.  
  64.             dataMap.put("list", list);
  65.  
  66.             String now = new SimpleDateFormat("yyyy-MM-dd HH-mm-ss").format(new Date());
  67.             String fileName = String.format("%s.docx", now);
  68.             System.out.println("当前导出的word3文件---->"+dir_word3+fileName);
  69.  
  70.             String top_time = now.substring(0, 10).replaceAll("-", ".");
  71.             dataMap.put("top_time", top_time);
  72.             toWord(dataMap, dir_word3+fileName, "word3.ftl");
  73. //            return dir_word3+fileName;
  74.             return getBytesByFile(dir_word3+fileName);
  75.         } catch (Exception e) {
  76.             msg = "error";
  77.             e.printStackTrace();
  78.         }
  79. //        return msg;
  80.         return null;
  81.     }
  82.  
  83.  
  84.  
  85.     @PostMapping("/downLoadWord1")
  86.     public byte[] word1(@RequestBody String data){
  87.         String msg = "";
  88.         Map<String, Object> dataMap = new HashMap<>();
  89.         List<Vo> list = new ArrayList<>();
  90.  
  91.         try {
  92.             JSONObject json = JSONObject.parseObject(data);
  93.             if(json.containsKey("news")){
  94.                 JSONArray newsArr = json.getJSONArray("news");
  95.                 for (int i = 0; i < newsArr.size(); i++) {
  96.                     Vo vo = new Vo();
  97.                     JSONObject jsonObject = newsArr.getJSONObject(i);
  98.                     vo.setId(i+1);
  99.                     String title = jsonObject.getString("title");
  100.                     vo.setBlogger("作者:"+jsonObject.getString("blogger"));
  101.                     list.add(vo);
  102.                 }
  103.  
  104.             }
  105.  
  106.             dataMap.put("list", list);
  107.  
  108.             String now = new SimpleDateFormat("yyyy-MM-dd HH-mm-ss").format(new Date());
  109.             String fileName = String.format("%s.docx", now);
  110.             System.out.println("当前导出的word1文件---->"+dir_word1+fileName);
  111.  
  112.             String year = now.substring(0, 4);
  113.             String month = now.substring(5, 7);
  114.             String day = now.substring(8, 10);
  115.             dataMap.put("year", year);
  116.             dataMap.put("month", month);
  117.             dataMap.put("day", day);
  118.             toWord(dataMap, dir_word1+fileName, "word1.ftl");
  119.  
  120.  
  121.             Document doc = new Document();
  122.             doc.loadFromFile(dir_word1+fileName);
  123.  
  124.  
  125.             //在文档最前面插入一个段落，写入文本并格式化
  126.             Paragraph parainserted = new Paragraph(doc);
  127.             doc.getSections().get(0).getParagraphs().insert(2,parainserted);
  128.             parainserted.getFormat().setHorizontalAlignment(HorizontalAlignment.Center);
  129.             doc.getSections().get(0).getParagraphs().get(1).appendTOC(1,3);
  130.  
  131.  
  132.  
  133.  
  134.             doc.updateTableOfContents();
  135.             //保存文档
  136.             doc.saveToFile(dir_word1+fileName, FileFormat.Docx_2010);
  137. //            return dir_word1+fileName;
  138.             return getBytesByFile(dir_word1+fileName);
  139.         } catch (Exception e) {
  140.             msg = "error";
  141.             e.printStackTrace();
  142.         }
  143. //        return msg;
  144.         return null;
  145.     }
  146.  
  147.  
  148.  
  149.     public  void toWord(Map<String, Object> dataMap, String docName, String ftlName) {
  150.         try {
  151.             //Configuration用于读取ftl文件
  152.             Configuration configuration = new Configuration();
  153.             configuration.setDefaultEncoding("utf-8");
  154.  
  155.             /*以下是两种指定ftl文件所在目录路径的方式, 注意这两种方式都是
  156.              * 指定ftl文件所在目录的路径,而不是ftl文件的路径
  157.              */
  158.             //指定路径的第一种方式(根据某个类的相对路径指定)
  159.             //configuration.setClassForTemplateLoading(this.getClass(),"");
  160.             configuration.setClassForTemplateLoading(WordController.class, "/templates");
  161.  
  162.             //指定路径的第二种方式,我的路径是C:/a.ftl
  163.             //configuration.setDirectoryForTemplateLoading(new File("C:\\Users\\张胜强\\Desktop"));
  164.  
  165.             // 输出文档路径及名称
  166.             File outFile = new File(docName);
  167.  
  168.             //以utf-8的编码读取ftl文件
  169.             Template t = configuration.getTemplate(ftlName, "utf-8");
  170.             Writer out = new BufferedWriter(new OutputStreamWriter(new FileOutputStream(outFile), "utf-8"), 10240);
  171.             t.process(dataMap, out);
  172.             out.flush();
  173.             out.close();
  174.         } catch (Exception e) {
  175.             e.printStackTrace();
  176.         }
  177.     }
  178.  
  179.  
  180.     //将文件转换成Byte数组
  181.     public byte[] getBytesByFile(String pathStr) {
  182.         File file = new File(pathStr);
  183.         System.out.println("文件大小为: " + file.length());
  184.         try {
  185.             FileInputStream fis = new FileInputStream(file);
  186.             ByteArrayOutputStream bos = new ByteArrayOutputStream(1024);
  187.             byte[] b = new byte[1024];
  188.             int n;
  189.             while ((n = fis.read(b)) != -1) {
  190.                 bos.write(b, 0, n);
  191.             }
  192.             fis.close();
  193.             byte[] data = bos.toByteArray();
  194.             bos.close();
  195.             return data;
  196.         } catch (Exception e) {
  197.             e.printStackTrace();
  198.         }
  199.         return null;
  200.     }
  201. }
  1. /**
  2.      * 通过模板生成Excel文件
  3.      * @param templateFileName 模板文件
  4.      * @param fileName 目标文件
  5.      * @param map 数据
  6.      */
  7.     public static void buildExcelByTemplate(String templateFileName, String fileName, Map map) {
  8.         OutputStream outStream = null;
  9.         try {
  10.             outStream = new FileOutputStream(fileName);
  11.             TemplateExportParams param = new TemplateExportParams(templateFileName, 0);
  12.             Workbook workbook = ExcelExportUtil.exportExcel(param, map);
  13.             workbook.write(outStream);
  14.         } catch (IOException e) {
  15.             log.error("根据模板生成Excel文件失败, 失败原因: {}", e);
  16.         } finally {
  17.             try {
  18.                 if (outStream != null) {
  19.                     outStream.close();
  20.                 }
  21.             } catch (IOException e) {
  22.                 e.printStackTrace();
  23.             }
  24.         }
  25.     }

声明：本文内容由网友自发贡献，不代表【wpsshop博客】立场，版权归原作者所有，本站不承担相应法律责任。如您发现有侵权的内容，请联系我们。转载请注明出处：https://www.wpsshop.cn/article/detail/55002
推荐阅读
相关标签

Copyright © 2003-2013 www.wpsshop.cn 版权所有，并保留所有权利。

  

闽ICP备14008679号