使用poi导出word

http://blog.csdn.net/fengyao1995/article/details/52443583 原文地址

项目需求要把页面上的分析结果导出为word文档，实现的办法是POI。查了一下网上很多方式都采用FreeMark，自己认为比较麻烦，所以还是采取了POI导出。之前的框架是SSH的，现在换成了spring MVC，这次也把导出代码整理了一下。

    页面效果是一个统计表，两个统计图，然后还有一些其他的统计数据，如下图所示：

首先需要一个word模板：

                                          

这个文档是自己制作的，里面每一个字母是占位符，将来数据是要放到这些字母的位置的。

下面是导出的代码：

    1、在页面上添加一个隐藏的表单，表单中的隐含域是要往后台提交的参数。

[html]  view plain  copy

 print ?

1. <form method="post" name="dataform" id="dataform" action="" style="display:none;">  
2.     <input type="hidden" id="pieChart" name="pieChart" value=""/>  
3.     <input type="hidden" id="barChart" name="barChart" value=""/>  
4.     <input type="hidden" id="versionId" name="versionId" value=""/>  
5. </form>  

    2、给表单隐含域赋值，并提交

[javascript]  view plain  copy

 print ?

1. //导出分析结果  
2. function exportReport(){  
3.     var exportUrl = rootpath +"/atservice/analysis/wordOutPut";  
4.     //饼图统计图的base64码  
5.     $("#pieChart").val(pieChart.getDataURL());  
6.     //柱状图统计图的base64码  
7.     $("#barChart").val(barChart.getDataURL());  
8.     var versionId = $("#versions").val();  
9.     if(versionId != ""){  
10.         versionId = versionId.substring(0,versionId.indexOf(","));  
11.     }  
12.     $("#versionId").val(versionId);  
13.     $("#dataform").attr("action",exportUrl);  
14.     $("#dataform").submit();  
15. }  

    3、Controller层获取数据，并传给相应的后台处理

[java]  view plain  copy

 print ?

1. @RequestMapping("/wordOutPut")  
2. public void wordOutPut(@Param("versionId") String versionId,  
3.         @Param("pieChart") String pieChart,  
4.         @Param("barChart") String barChart, HttpServletRequest request,  
5.         HttpServletResponse response) throws IOException {  
6.     response.setCharacterEncoding(ATConstants.CHARACTER_ENCODING);  
7.     response.addHeader("Access-Control-Allow-Origin", "*");  
8.     File file = wordOutputService.wordOutPut(versionId, pieChart, barChart);  
9.     outPut(file, response);  
10. }  
11.   
12. public static void outPut(File file, HttpServletResponse response) {  
13.     try {  
14.         // 下载  
15.         OutputStream toClient = null;  
16.         InputStream is = null;  
17.         try {  
18.             String realFilePath = file.getAbsolutePath();//  
19.             // 创建文件目录  
20.             // String fileName = new String(("总体分析导出结果").getBytes("UTF-8"),  
21.             // "ISO8859_1") + ".docx";  
22.             String fileName = "总体分析结果" + ".docx";  
23.   
24.             // 设置response的Header  
25.             response.addHeader(  
26.                     "Content-disposition",  
27.                     "attachment;filename="  
28.                             + java.net.URLEncoder.encode(fileName, "UTF-8"));  
29.             toClient = response.getOutputStream();  
30.             response.setContentType("application/octet-stream");  
31.             // 以流的形式下载文件。  
32.             is = new FileInputStream(realFilePath);  
33.             byte b[] = new byte[1024];  
34.             int len = -1;  
35.             while ((len = is.read(b)) != -1)  
36.                 toClient.write(b, 0, len);  
37.             toClient.flush();  
38.   
39.         } catch (IOException ex) {  
40.             throw ex;  
41.         } finally {  
42.             closeOut(toClient);  
43.             closeIn(is);  
44.         }  
45.   
46.     } catch (Exception e) {  
47.         log.error("下载附件出错，错误内容：", e);  
48.   
49.     }  
50. }  
51.   
52. public static void closeIn(InputStream in) {  
53.     try {  
54.         if (in != null) {  
55.             in.close();  
56.         }  
57.     } catch (Exception e) {  
58.         log.error("closeIn", e);  
59.         in = null;  
60.     }  
61. }  
62.   
63. public static void closeOut(OutputStream out) {  
64.     try {  
65.         if (out != null) {  
66.             out.close();  
67.         }  
68.     } catch (Exception e) {  
69.         log.error("closeIn", e);  
70.         out = null;  
71.     }  
72. }  

    

     4、后台进行处理，处理的过程包括创建一个word文档，然后读取这个文档的位置，将数据以流的形式写入文档，最后保存下载。

[java]  view plain  copy

 print ?

1. //Service层方法：  
2. import java.io.File;  
3. import java.io.FileOutputStream;  
4. import java.net.URLDecoder;  
5. import java.util.ArrayList;  
6. import java.util.HashMap;  
7. import java.util.List;  
8. import java.util.Map;  
9. import java.util.Properties;  
10.   
11. import org.apache.commons.lang3.StringUtils;  
12. import org.apache.log4j.Logger;  
13. import org.apache.poi.xwpf.usermodel.XWPFDocument;  
14. import org.springframework.beans.factory.annotation.Autowired;  
15. import org.springframework.jdbc.core.JdbcTemplate;  
16. import org.springframework.stereotype.Service;  
17.   
18. import com.at21.landscaping.dao.LandAllAnalysisMapper;  
19. import com.at21.landscaping.domain.WordConditionModel;  
20. import com.at21.landscaping.util.ExportWordUtils;  
21. import com.at21.landscaping.util.FileUtils;  
22. import com.at21.landscaping.util.SQLUtil;  
23.   
24. @Service  
25. public class WordOutputService {  
26.     @Autowired  
27.     private JdbcTemplate jdbc;  
28.   
29.     @Autowired  
30.     private SQLUtil sqlutil;  
31.     private Properties pro;  
32.   
33.     private static final Logger log = Logger.getLogger(WordOutputService.class);  
34.     private WordConditionModel wordConditionModel = new WordConditionModel();  
35.   
36.     @Autowired  
37.     private LandAllAnalysisMapper landAnalysisMapper;  
38.   
39.     public File wordOutPut(String versionId, String pieChart, String barChart) {  
40.         // 获取所有参数  
41.         Map<String, String> map = new HashMap<String, String>();  
42.         // request.getParameterMap();  
43.         map.put("versionId", versionId);  
44.         map.put("pieChart", pieChart);  
45.         map.put("barChart", barChart);  
46.         wordConditionModel.setMap(map);  
47.         // 得到输出的EXCEL的默认file对象  
48.         File file = null;  
49.         try {  
50.             file = this.getWordFile();  
51.         } catch (Exception e) {  
52.             e.printStackTrace();  
53.         }  
54.         return file;  
55.     }  
56.   
57.     public File getWordFile() throws Exception {  
58.         Map<String, Object> param = this.getParam();  
59.         String templatename = this.getTemplateName();  
60.         return this.outPut(param, templatename);  
61.     }  
62.   
63.     public File outPut(Map<String, Object> param, String templatename)  
64.             throws Exception {  
65.         try {  
66.   
67.             String filePath = URLDecoder.decode(WordOutputService.class  
68.                     .getResource("/").getPath(), "UTF-8");// +  
69.             if (filePath.indexOf("WEB-INF") != -1) {  
70.                 filePath = filePath.substring(0, filePath.indexOf("WEB-INF")  
71.                         + ("WEB-INF").length());  
72.             }  
73.   
74.             filePath += File.separator + templatename;  
75.             XWPFDocument doc = ExportWordUtils.generateWord(param, filePath);  
76.   
77.             File docTemplaFile = new File(filePath);  
78.   
79.             File file = FileUtils.copyFile(docTemplaFile);  
80.   
81.             FileOutputStream fopts = new FileOutputStream(file);  
82.             doc.write(fopts);  
83.             fopts.close();  
84.             return file;  
85.         } catch (Exception e) {  
86.             log.error(e);  
87.             throw e;  
88.         }  
89.     }  
90.   
91.     public Map<String, Object> getParam() throws Exception {  
92.         String versionId = this.wordConditionModel.getMap().get("versionId")  
93.                 .toString();  
94.         String versionName = "";  
95.         String zmj = "";  
96.         String lhmj = "";  
97.         String lhfgl = "";  
98.         List<Map<String, Object>> areaList = new ArrayList<Map<String, Object>>();  
99.         List<Map<String, Object>> tableList = new ArrayList<Map<String, Object>>();  
100.         if (versionId == "" && versionId.equals("")) {  
101.             versionId = landAnalysisMapper.queryNewestVersionGUID();  
102.         }  
103.   
104.         pro = sqlutil.getProperties();  
105.         String asql = pro.getProperty("ztfxArea");  
106.         asql = asql.replace("$versionId$", versionId);  
107.         areaList = jdbc.queryForList(asql);  
108.   
109.         String tsql = pro.getProperty("ztfxTable");  
110.         tsql = tsql.replace("$versionId$", versionId);  
111.         tableList = jdbc.queryForList(tsql);  
112.   
113.         if (areaList.size() != 0) {  
114.             versionName = areaList.get(0).get("periodname") + "";  
115.             zmj = areaList.get(0).get("allarea") + "";  
116.             lhmj = areaList.get(0).get("allgreenarea") + "";  
117.             lhfgl = areaList.get(0).get("grencoverrate") + "";  
118.         }  
119.   
120.         Map<String, Object> param = new HashMap<String, Object>();  
121.         param.put("a", versionName);// 数据集版本名称  
122.         param.put("b", zmj);// 建成区总面积  
123.         param.put("c", lhmj);// 建成区绿化覆盖面积  
124.         param.put("d", lhfgl);// 建成区绿化覆盖率  
125.   
126.         // 饼状图  
127.         String barChartbase64 = this.wordConditionModel.getMap()  
128.                 .get("barChart");  
129.         if (StringUtils.isNotBlank(barChartbase64)) {  
130.             barChartbase64 = barChartbase64.substring(barChartbase64  
131.                     .indexOf(",") + 1);  
132.             Map<String, Object> header3 = new HashMap<String, Object>();  
133.             header3.put("width", 400);  
134.             header3.put("height", 200);  
135.             header3.put("type", "jpg");  
136.             header3.put("content",  
137.                     ExportWordUtils.base642ByteArray(barChartbase64));  
138.             param.put("e", header3);  
139.         }  
140.   
141.         // 柱状图  
142.         String pieChartbase64 = this.wordConditionModel.getMap()  
143.                 .get("pieChart");  
144.         if (StringUtils.isNotBlank(pieChartbase64)) {  
145.             pieChartbase64 = pieChartbase64.substring(pieChartbase64  
146.                     .indexOf(",") + 1);  
147.             Map<String, Object> header3 = new HashMap<String, Object>();  
148.             header3.put("width", 400);  
149.             header3.put("height", 200);  
150.             header3.put("type", "jpg");  
151.             header3.put("content",  
152.                     ExportWordUtils.base642ByteArray(pieChartbase64));  
153.             param.put("f", header3);  
154.         }  
155.   
156.         param.put("g", tableList);// 统计表  
157.         return param;  
158.     }  
159.   
160.     public String getTemplateName() throws Exception {  
161.         String tamplateName = "/wordtemplate/ztfx.docx";  
162.         return tamplateName;  
163.     }  
164. }  

[java]  view plain  copy

 print ?

1. //ExportWordUtils工具类代码  
2. package com.at21.landscaping.util;  
3.   
4. import java.io.ByteArrayInputStream;  
5. import java.io.File;  
6. import java.io.IOException;  
7. import java.io.InputStream;  
8. import java.net.URLDecoder;  
9. import java.util.Iterator;  
10. import java.util.List;  
11. import java.util.Map;  
12. import java.util.Map.Entry;  
13.   
14. import org.apache.commons.io.FileUtils;  
15. import org.apache.http.HttpResponse;  
16. import org.apache.http.client.HttpClient;  
17. import org.apache.http.client.methods.HttpGet;  
18. import org.apache.http.impl.client.DefaultHttpClient;  
19. import org.apache.http.util.EntityUtils;  
20. import org.apache.poi.POIXMLDocument;  
21. import org.apache.poi.openxml4j.opc.OPCPackage;  
22. import org.apache.poi.util.Units;  
23. import org.apache.poi.xwpf.usermodel.Document;  
24. import org.apache.poi.xwpf.usermodel.XWPFDocument;  
25. import org.apache.poi.xwpf.usermodel.XWPFParagraph;  
26. import org.apache.poi.xwpf.usermodel.XWPFRun;  
27. import org.apache.poi.xwpf.usermodel.XWPFTable;  
28. import org.apache.poi.xwpf.usermodel.XWPFTableCell;  
29. import org.apache.poi.xwpf.usermodel.XWPFTableRow;  
30.   
31. import com.at21.base64.Base64;  
32. import com.at21.landscaping.service.WordOutputService;  
33.   
34. /** 
35.  * 适用于word 2007 poi 版本 3.7 
36.  */  
37. public class ExportWordUtils {  
38.   
39.     /** 
40.      * 根据指定的参数值、模板，生成 word 文档 
41.      *  
42.      * @param param 
43.      *            需要替换的变量 
44.      * @param template 
45.      *            模板 
46.      */  
47.     public static XWPFDocument generateWord(Map<String, Object> param,  
48.             String template) {  
49.         XWPFDocument doc = null;  
50.         OPCPackage pack = null;  
51.         try {  
52.             pack = POIXMLDocument.openPackage(template);  
53.             doc = new XWPFDocument(pack);  
54.             if (param != null && param.size() > 0) {  
55.   
56.                 // 处理段落 - 文字或照片  
57.                 List<XWPFParagraph> paragraphList = doc.getParagraphs();  
58.                 processParagraphs(paragraphList, param, doc, null, 0);  
59.   
60.                 // 处理表格 - 文字或照片  
61.                 List<XWPFTable> tablelist = doc.getTables();  
62.                 for (int i = 0; i < tablelist.size(); i++) {  
63.                     XWPFTable xwpfTable = tablelist.get(i);  
64.                     List<XWPFTableRow> rows = xwpfTable.getRows();  
65.                     for (int j = 0; j < rows.size(); j++) {  
66.                         XWPFTableRow row = rows.get(j);  
67.                         List<XWPFTableCell> cells = row.getTableCells();  
68.                         for (int k = 0; k < cells.size(); k++) {  
69.                             XWPFTableCell cell = cells.get(k);  
70.                             List<XWPFParagraph> paragraphListTable = cell  
71.                                     .getParagraphs();  
72.                             processParagraphs(paragraphListTable, param, doc,  
73.                                     xwpfTable, j);  
74.                         }  
75.                     }  
76.                 }  
77.   
78.             }  
79.         } catch (Exception e) {  
80.             e.printStackTrace();  
81.         }  
82.         return doc;  
83.     }  
84.   
85.     /** 
86.      * 处理段落 
87.      *  
88.      * @param paragraphList 
89.      * @throws Exception 
90.      */  
91.     public static void processParagraphs(List<XWPFParagraph> paragraphList,  
92.             Map<String, Object> param, XWPFDocument doc, XWPFTable xwpfTable,  
93.             int rownum) throws Exception {  
94.         if (paragraphList != null && paragraphList.size() > 0) {  
95.             for (XWPFParagraph paragraph : paragraphList) {  
96.                 List<XWPFRun> runs = paragraph.getRuns();  
97.                 for (XWPFRun run : runs) {  
98.                     String text = run.getText(0);  
99.                     System.out.println(text);  
100.                     if (text != null) {  
101.                         boolean isSetText = false;  
102.                         for (Entry<String, Object> entry : param.entrySet()) {  
103.                             String key = entry.getKey();  
104.                             if (text.indexOf(key) != -1) {  
105.                                 isSetText = true;  
106.                                 Object value = entry.getValue();  
107.                                 if (value instanceof String) {// 文本替换  
108.                                     text = text.replace(key, value.toString());  
109.                                 } else if (value instanceof Map) {// 图片替换  
110.                                     text = text.replace(key, "");  
111.                                     Map pic = (Map) value;  
112.                                     int width = Integer.parseInt(pic  
113.                                             .get("width") + "");  
114.                                     int height = Integer.parseInt(pic  
115.                                             .get("height") + "");  
116.   
117.                                     byte[] byteArray = (byte[]) pic  
118.                                             .get("content");  
119.                                     if (byteArray != null) {  
120.   
121.                                         ByteArrayInputStream byteInputStream = new ByteArrayInputStream(  
122.                                                 byteArray);  
123.                                         try {  
124.                                             run.addPicture(byteInputStream,  
125.                                                     Document.PICTURE_TYPE_JPEG,  
126.                                                     "", Units.toEMU(width),  
127.                                                     Units.toEMU(height));  
128.                                         } catch (Exception e) {  
129.                                             e.printStackTrace();  
130.                                         }  
131.                                     }  
132.   
133.                                 } else if (value instanceof List  
134.                                         && xwpfTable != null) {// 图片替换  
135.                                     text = text.replace(key, "");  
136.   
137.                                     List<Map<String, Object>> _table = (List<Map<String, Object>>) value;  
138.   
139.                                     for (int i = 0; i < _table.size(); i++) {  
140.                                         // get row  
141.                                         if (i == 0) {  
142.                                             XWPFTableRow row = xwpfTable  
143.                                                     .getRow(rownum);  
144.                                             Map<String, Object> rowdata = _table  
145.                                                     .get(i);  
146.                                             int init = 0;  
147.                                             for (Iterator iterator = rowdata  
148.                                                     .keySet().iterator(); iterator  
149.                                                     .hasNext();) {  
150.                                                 Object _key = iterator.next();  
151.                                                 Object _value = rowdata  
152.                                                         .get(_key);  
153.                                                 XWPFTableCell cell = row  
154.                                                         .getCell(init);  
155.                                                 cell.setText(_value + "");  
156.                                                 init++;  
157.                                             }  
158.   
159.                                         } else {  
160.                                             // create row  
161.                                             XWPFTableRow row = xwpfTable  
162.                                                     .createRow();  
163.                                             Map<String, Object> rowdata = _table  
164.                                                     .get(i);  
165.                                             int init = 0;  
166.                                             for (Iterator iterator = rowdata  
167.                                                     .keySet().iterator(); iterator  
168.                                                     .hasNext();) {  
169.                                                 Object _key = iterator.next();  
170.                                                 Object _value = rowdata  
171.                                                         .get(_key);  
172.                                                 XWPFTableCell cell = row  
173.                                                         .getCell(init);  
174.                                                 cell.setText(_value + "");  
175.                                                 init++;  
176.                                             }  
177.                                         }  
178.                                     }  
179.                                 }  
180.                             }  
181.                         }  
182.                         if (isSetText) {  
183.                             run.setText(text, 0);  
184.                         }  
185.                     }  
186.                 }  
187.             }  
188.         }  
189.     }  
190.   
191.     /** 
192.      * 将输入流中的数据写入字节数组 
193.      *  
194.      * @param in 
195.      * @return 
196.      */  
197.     public static byte[] inputStream2ByteArray(InputStream in, boolean isClose) {  
198.         byte[] byteArray = null;  
199.         try {  
200.             int total = in.available();  
201.             byteArray = new byte[total];  
202.             in.read(byteArray);  
203.         } catch (IOException e) {  
204.             e.printStackTrace();  
205.         } finally {  
206.             if (isClose) {  
207.                 try {  
208.                     in.close();  
209.                 } catch (Exception e2) {  
210.                 }  
211.             }  
212.         }  
213.         return byteArray;  
214.     }  
215.   
216.     /** 
217.      * 将输入流中的数据写入字节数组 
218.      *  
219.      * @param in 
220.      * @return 
221.      */  
222.     public static byte[] base642ByteArray(String base64str) {  
223.         byte[] byteArray = null;  
224.         try {  
225.             byteArray = Base64.decode(base64str);  
226.         } catch (Exception e) {  
227.             e.printStackTrace();  
228.         }  
229.         return byteArray;  
230.     }  
231.   
232.     /** 
233.      * 将输入流中的数据写入字节数组 
234.      *  
235.      * @param in 
236.      * @return 
237.      */  
238.     public static byte[] localImage2ByteArray(String filename) {  
239.         byte[] byteArray = null;  
240.         try {  
241.             String filePath = URLDecoder.decode(WordOutputService.class  
242.                     .getResource("/").getPath(), "UTF-8");// +  
243.             // excelTemplateUrl;  
244.             if (filePath.indexOf("WEB-INF") != -1) {  
245.                 filePath = filePath.substring(0, filePath.indexOf("WEB-INF")  
246.                         + ("WEB-INF").length());  
247.             }  
248.   
249.             filename = filePath + File.separator + "wordtemplate"  
250.                     + File.separator + filename;  
251.             byteArray = FileUtils.readFileToByteArray(new File(filename));  
252.         } catch (Exception e) {  
253.             e.printStackTrace();  
254.         }  
255.         return byteArray;  
256.     }  
257.   
258.     public static byte[] remoteImage2ByteArray(String imageUrl) {  
259.         byte[] byteArray = null;  
260.         try {  
261.             HttpClient httpClient = new DefaultHttpClient();  
262.             // 建立HttpGet  
263.             HttpGet httpGet = new HttpGet(imageUrl);  
264.   
265.             // 添加参数  
266.             httpGet.getParams().setParameter("http.conn-manager.timeout",  
267.                     Long.valueOf(1000L));  
268.             httpGet.getParams().setParameter("http.connection.timeout",  
269.                     Integer.valueOf(2000));  
270.             httpGet.getParams().setParameter("http.socket.timeout",  
271.                     Integer.valueOf(10000));  
272.   
273.             // 发送请求返回httpResponse  
274.             HttpResponse httpResponse = httpClient.execute(httpGet);  
275.             // 请求返回的状态码，如果为200则成功，否在失败  
276.             int statusCode = httpResponse.getStatusLine().getStatusCode();  
277.             if (statusCode == 200) {  
278.                 byteArray = EntityUtils.toByteArray(httpResponse.getEntity());  
279.             }  
280.   
281.         } catch (Exception e) {  
282.             e.printStackTrace();  
283.         }  
284.         return byteArray;  
285.     }  
286. }  

[java]  view plain  copy

 print ?

1. //FileUtils工具类代码，这是对FileUtils类的封装  
2. package com.at21.landscaping.util;  
3.   
4. import java.io.File;  
5. import java.util.Calendar;  
6.   
7. public class FileUtils {  
8.       
9.     public static File copyFile(File file)throws Exception {  
10.         try{  
11.             File dest = new File(Constants.DEFAULTTMPFILEURL+Calendar.getInstance().getTime().getTime()+".xls");  
12.             org.apache.commons.io.FileUtils.copyFile(file, dest);  
13.             return dest;  
14.         }catch(Exception e){  
15.             throw e;  
16.         }  
17.     }  
18. }  

    以上就是导出word文档的全部内容，导出的word文档的截图忘了截了，下次再给补上。如果有什么瑕疵，还请过路的各位大牛指点一二。