jxl导出excel --- 居中 自动换行 边框 样式

1. public void writeToExl_GW(ByteArrayOutputStream byteOs)throws Exception{   
2.         try{   
3.             int timeLength = 0;   
4.             ITrendService trendService = new TrendServiceImpl();   
5.             if(null != stepTime && !"".equals(stepTime)){   
6.                 timeLength = Integer.valueOf(stepTime);   
7.             }   
8.             gwjcList=trendService.querygwjcList(beginTime,endTime,timeLength);   
9.             String filename="轨温监测历史查询"+ new SimpleDateFormat("yyyy-MM-dd").format(new Date(System.currentTimeMillis())) + ".xls";    
10.             exportFileName = new String(filename.getBytes("GBK"), "ISO-8859-1");   
11.             WritableWorkbook wbook = Workbook.createWorkbook(byteOs); //建立excel文件    
12.             WritableSheet wsheet = wbook.createSheet("轨温监测历史查询", 0); //工作表名称    
13.             WritableFont wfont1 = new WritableFont(WritableFont.ARIAL, 9,      //初始化一些样式   
14.                     WritableFont.NO_BOLD, false,   
15.                     jxl.format.UnderlineStyle.NO_UNDERLINE, jxl.format.Colour.RED);   
16.             WritableFont wfont2 = new WritableFont(WritableFont.ARIAL, 10);   
17.             WritableFont wfont3 = new WritableFont(WritableFont.ARIAL, 9,   
18.                     WritableFont.NO_BOLD, false,   
19.                     jxl.format.UnderlineStyle.NO_UNDERLINE,   
20.                     jxl.format.Colour.AUTOMATIC);   
21.             WritableFont wfont4 = new WritableFont(WritableFont.ARIAL, 10);   
22.             WritableCellFormat titleFormat1 = new WritableCellFormat(wfont1);   
23.             WritableCellFormat titleFormat2 = new WritableCellFormat(wfont2);   
24.             WritableCellFormat titleFormat3 = new WritableCellFormat(wfont3);   
25.             WritableCellFormat titleFormat3_1 = new WritableCellFormat(wfont3);   
26.             WritableCellFormat titleFormat4 = new WritableCellFormat(wfont4);   
27.             titleFormat1.setVerticalAlignment(VerticalAlignment.CENTRE);       
28.             titleFormat1.setAlignment(Alignment.CENTRE);   
29.             titleFormat1.setWrap(true);   
30.                  
31.             titleFormat2.setVerticalAlignment(VerticalAlignment.CENTRE);   //设置居中对齐   
32.             titleFormat2.setAlignment(Alignment.CENTRE);//设置居中对齐（这俩哪个是上下/左右对齐也没验证过）   
33.             titleFormat2.setBackground(jxl.format.Colour.GREY_25_PERCENT);//单元格背景色   
34.             titleFormat3.setVerticalAlignment(VerticalAlignment.CENTRE);   
35.             titleFormat3.setAlignment(Alignment.CENTRE);   
36.             titleFormat3.setWrap(true);//是否自动换行   
37.             titleFormat3.setBorder(jxl.format.Border.ALL,jxl.format.BorderLineStyle.THIN);//给单元格加边框          titleFormat3_1.setVerticalAlignment(VerticalAlignment.CENTRE);   
38.             titleFormat3_1.setAlignment(Alignment.CENTRE);   
39.             titleFormat3_1.setWrap(true);   
40.             titleFormat3_1.setBackground(jxl.format.Colour.ORANGE);   
41.             titleFormat3_1.setBorder(jxl.format.Border.ALL,jxl.format.BorderLineStyle.THIN);//Biankuang   
42.             titleFormat4.setVerticalAlignment(VerticalAlignment.CENTRE);   
43.             titleFormat4.setAlignment(Alignment.CENTRE);   
44.             titleFormat4.setBackground(jxl.format.Colour.GRAY_25);   
45.             titleFormat4.setBorder(jxl.format.Border.ALL,jxl.format.BorderLineStyle.HAIR);//Biankuang   
46.             StringBuffer title = new StringBuffer();   
47.             title.append("轨温监测查询条件:");   
48.             title.append("开始时间 [");   
49.             title.append(beginTime);   
50.             title.append("]");   
51.             title.append(" 结束时间:[");   
52.             title.append(endTime);   
53.             title.append("]");   
54.             wsheet.setColumnView(0, 19);   
55.             wsheet.setRowView(0, 600);   
56.             wsheet.addCell(new Label(0,0,title.toString(),titleFormat1));   
57.             if("1".equals(tdzt)){   
58.                 title.append(" 启用通道状态");   
59.                 //设置表头行合并单元格   
60.                 wsheet.mergeCells(0, 0, 9, 0);   
61.                 int rows =1;   
62.                 wsheet.addCell(new Label(0,rows,"时间",titleFormat4));   
63.                 wsheet.addCell(new Label(1,rows,"左温度(℃)",titleFormat4));   
64.                 wsheet.addCell(new Label(2,rows,"右温度(℃)",titleFormat4));   
65.                 wsheet.addCell(new Label(3,rows,"环温(℃)",titleFormat4));   
66.                 wsheet.addCell(new Label(4,rows,"通道一",titleFormat4));   
67.                 wsheet.addCell(new Label(5,rows,"通道二",titleFormat4));   
68.                 wsheet.addCell(new Label(6,rows,"通道三",titleFormat4));   
69.                 wsheet.addCell(new Label(7,rows,"通道四",titleFormat4));   
70.                 wsheet.addCell(new Label(8,rows,"通道五",titleFormat4));   
71.                 wsheet.addCell(new Label(9,rows,"通道六",titleFormat4));   
72.                      
73.                 for(int i=0;i<gwjcList.size();i++){   
74.                     wsheet.addCell(new Label(0,rows+1,gwjcList.get(i).getSj(),titleFormat3));   
75.                     wsheet.addCell(new Label(1,rows+1,gwjcList.get(i).getZwd(),titleFormat3));   
76.                     wsheet.addCell(new Label(2,rows+1,gwjcList.get(i).getYwd(),titleFormat3));   
77.                     wsheet.addCell(new Label(3,rows+1,gwjcList.get(i).getHw(),titleFormat3));   
78.                     wsheet.addCell(new Label(4,rows+1,Integer.valueOf(gwjcList.get(i).getTd1zt())==1?"正   常":"异常",Integer.valueOf(gwjcList.get(i).getTd1zt())==1?titleFormat3:titleFormat3_1));   
79.                     wsheet.addCell(new Label(5,rows+1,Integer.valueOf(gwjcList.get(i).getTd2zt())==1?"正常":"异常",Integer.valueOf(gwjcList.get(i).getTd2zt())==1?titleFormat3:titleFormat3_1));   
80.                     wsheet.addCell(new Label(6,rows+1,Integer.valueOf(gwjcList.get(i).getTd3zt())==1?"正常":"异常",Integer.valueOf(gwjcList.get(i).getTd3zt())==1?titleFormat3:titleFormat3_1));   
81.                     wsheet.addCell(new Label(7,rows+1,Integer.valueOf(gwjcList.get(i).getTd4zt())==1?"正常":"异常",Integer.valueOf(gwjcList.get(i).getTd4zt())==1?titleFormat3:titleFormat3_1));   
82.                     wsheet.addCell(new Label(8,rows+1,Integer.valueOf(gwjcList.get(i).getTd5zt())==1?"正常":"异常",Integer.valueOf(gwjcList.get(i).getTd5zt())==1?titleFormat3:titleFormat3_1));   
83.                     wsheet.addCell(new Label(9,rows+1,Integer.valueOf(gwjcList.get(i).getTd6zt())==1?"正常":"异常",Integer.valueOf(gwjcList.get(i).getTd6zt())==1?titleFormat3:titleFormat3_1));   
84.                     rows= rows +1;   
85.                 }   
86.             }else{   
87.                 wsheet.mergeCells(0, 0, 3, 0);   
88.                 int rows =1;   
89.                 wsheet.addCell(new Label(0,rows,"时间",titleFormat4));   
90.                 wsheet.addCell(new Label(1,rows,"左温度(℃)",titleFormat4));   
91.                 wsheet.addCell(new Label(2,rows,"右温度(℃)",titleFormat4));   
92.                 wsheet.addCell(new Label(3,rows,"环温(℃)",titleFormat4));   
93.                 for(int i=0;i<gwjcList.size();i++){   
94.                     wsheet.addCell(new Label(0,rows+1,gwjcList.get(i).getSj(),titleFormat3));   
95.                     wsheet.addCell(new Label(1,rows+1,gwjcList.get(i).getZwd(),titleFormat3));   
96.                     wsheet.addCell(new Label(2,rows+1,gwjcList.get(i).getYwd(),titleFormat3));   
97.                     wsheet.addCell(new Label(3,rows+1,gwjcList.get(i).getHw(),titleFormat3));   
98.                     rows = rows +1 ;   
99.                 }   
100.             }   
101.             contentType = "application/vnd.ms-excel";   
102.             wbook.write();   
103.             wbook.close();   
104.         }catch(Exception e){   
105.             e.printStackTrace();   
106.         }   
107.     }   
108.     public String exportGW(){   
109.         try{   
110.             ByteArrayOutputStream byteOs = new ByteArrayOutputStream();   
111.             writeToExl_GW(byteOs);   
112.             byteOs.flush();   
113.             excelStream = new ByteArrayInputStream(byteOs.toByteArray(),0,byteOs.toByteArray().length);   
114.             byteOs.close();   
115.         }catch(Exception e){   
116.             e.printStackTrace();   
117.         }   
118.         return SUCCESS;   
119.     }