java excel读写组件jxl使用

使用起来很简单，就不多说了，只把代码贴出来

1. package com.yinbo.satisfy.web.struts;
3. import javax.servlet.ServletOutputStream;
4. import javax.servlet.http.HttpServletRequest;
5. import javax.servlet.http.HttpServletResponse;
6. import org.apache.struts.action.Action;
7. import org.apache.struts.action.ActionForm;
8. import org.apache.struts.action.ActionForward;
9. import org.apache.struts.action.ActionMapping;
11. //import com.lowagie.text.List;
12. import java.util.List;
13. import com.yinbo.satisfy.service.satisfy.SatisfyManage;
14. import com.yinbo.satisfy.service.sysmanage.BranchManage;
15. import com.yinbo.satisfy.service.sysmanage.ParamManage;
16. import com.yinbo.satisfy.util.CommonUtils;
17. import com.yinbo.satisfy.vo.Branch;
18. import com.yinbo.satisfy.vo.Suggestion;
19. import com.yinbo.satisfy.vo.SysParam;
21. import java.io.*;
23. import jxl.Workbook;
24. import jxl.write.Label;
25. import jxl.write.WritableSheet;
26. import jxl.write.WritableWorkbook;
27. import jxl.write.WriteException;
29. public class QuestionAction extends Action {
31.     private SatisfyManage satisfyManage;
32.     private BranchManage branchManage;
33.     private ParamManage paramManage;
34.     
35.     /** 
36.      * Method execute
37.      * @param mapping
38.      * @param form
39.      * @param request
40.      * @param response
41.      * @return ActionForward
42.      */
43.     public ActionForward execute(ActionMapping mapping, ActionForm form,
44.             HttpServletRequest request, HttpServletResponse response) {
45.     
46.         String excelFileName = "c://testaaa.xls";
47.         
48.          //
49.              String branchId = request.getParameter("branchId");
50.         String level = request.getParameter("level");
51.         List list = satisfyManage.getQuestionData(branchId, level);
52.         String result[][] = new String[list.size()][5];
53.         for(int i=0; i<list.size(); i++) {
54.             Suggestion sug = (Suggestion)list.get(i);
55.             result[i][0]=sug.getSugContent();
56.             ///System.out.println(sug.getSugContent());
57.         }
58.         
59.         //添加所在单位
60.         Branch branch = branchManage.getBranchById(branchId);
61.         String branchName = branch.getBranchName();
62.         if(CommonUtils.isEmpty(branchName)) branchName = "所有机构";
63.         
64.         //添加级别
65.         SysParam param = paramManage.getParam("3", level);
66.         String paramName = param.getParamName();
67.         if(CommonUtils.isEmpty(paramName)) paramName = "所有级别";
68.         
69.         try {
70.             String strFileName = "question.xls";
71.             strFileName = java.net.URLEncoder.encode(strFileName, "UTF-8");//处理中文文件名的问题
72.             strFileName = new String(strFileName.getBytes("UTF-8"),"GBK");//处理中文文件名的问题
73.             response.reset();
74.             response.setCharacterEncoding("UTF-8");
75.             response.setContentType("application/vnd.ms-excel");
76.             response.setHeader("Content-Disposition","attachment; filename=" + strFileName);
77.             ByteArrayOutputStream baos = new ByteArrayOutputStream();
78.             
79.           //创建可写入的Excel工作薄
80.           //WritableWorkbook book = Workbook.createWorkbook(new File(excelFileName));
81.             WritableWorkbook book = Workbook.createWorkbook(baos);
82.           
83.           // 写工作表名字
84.           WritableSheet sheet = book.createSheet("XXX建议", 0);
86.           //此处可以设置列的宽度
87.           int column = 0;
88.           sheet.setColumnView(column++, 30);
89.           sheet.setColumnView(column++, 30);
90.           sheet.setColumnView(column++, 30);
91.           sheet.setColumnView(column++, 30);
93.           sheet.addCell(new Label(0, 0, "建议(" + branchName + ")(" + paramName + ")")); // 增加excel单元格
94.           //sheet.addCell(new Label(1, 0, "部门名称")); // 增加excel单元格
95.           //sheet.addCell(new Label(2, 0, "部门类型")); // 增加excel单元格
96.           //sheet.addCell(new Label(3, 0, "综合成绩")); // 增加excel单元格
98.           // result = getSelectResultWithStringArray(ds, sql);
99.             int rows = result.length;
100.             if (rows != 0) {
101.                 int cols = result[0].length;
102.                 for (int i = 0; i < rows; i++) {
103.                     for (int j = 0; j < cols; j++) {
104.                         sheet.addCell(new Label(j, i + 1, result[i][j]));
105.                     }
106.                 }
107.             }
109.           book.write(); // 写入byte输出流数组
110.           book.close(); // jxl对象关闭
112.           ServletOutputStream out = response.getOutputStream();
113.         baos.writeTo(out);
114.          out.flush();
115.             
116.         } catch (IOException e) {
117.           e.printStackTrace();
118.         } catch (WriteException e) {
119.           e.printStackTrace();
120.         }
121.        
122.         return null;
123.     }
125.     public SatisfyManage getSatisfyManage() {
126.         return satisfyManage;
127.     }
129.     public void setSatisfyManage(SatisfyManage satisfyManage) {
130.         this.satisfyManage = satisfyManage;
131.     }
133.     public BranchManage getBranchManage() {
134.         return branchManage;
135.     }
137.     public void setBranchManage(BranchManage branchManage) {
138.         this.branchManage = branchManage;
139.     }
141.     public ParamManage getParamManage() {
142.         return paramManage;
143.     }
145.     public void setParamManage(ParamManage paramManage) {
146.         this.paramManage = paramManage;
147.     }
149. }