javaweb ssh jxl 导出Excel实例

1、JavaWeb SSH JXL 导出ExcelJsp:function aaa() / 提交方式一定不能为ajax，否则不会出现保存对话框 var frm=document.getElementById(searchwmsgform); frm.action=/select.do?dispatch=exportExcel; frm.submit();Action：/* * 导出Excel * param mapping * param form * param request * param response * return */public ActionForward exportExce

2、l(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) try String filePath = request.getRealPath(/);File file = new File(filePath + 报警信息.xls);WritableWorkbook wwb = Workbook.createWorkbook(file); /生成ExcelselectService.exportExcel(wwb);try /创建一个缓冲输入流对象 Buf

3、feredInputStream br = new BufferedInputStream( new FileInputStream(file); byte buf = new byte1024; int len = 0; response.reset(); / 非常重要 response.setContentType(application/x-msdownload); response.setHeader(Content-Disposition, attachment; filename= + new String(file.getName().getBytes(),iso-8859-1)

4、;/创建输出流对象 OutputStream outStream = response.getOutputStream(); /开始输出 while (len = br.read(buf) 0) outStream.write(buf, 0, len); /关闭流对象 br.close(); outStream.close(); catch (FileNotFoundException e) e.printStackTrace(); catch (IOException e) e.printStackTrace(); if (file.exists() /下载完毕删除文件 file.delet

5、e(); catch (Exception e) / TODO Auto-generated catch blocke.printStackTrace();return null;实现类中：public void exportExcel(WritableWorkbook book) throws Exception try WritableSheet sheet = book.createSheet(第一页, 0);/字段字体jxl.write.WritableFont wfc1 = new jxl.write.WritableFont( WritableFont.ARIAL, 13, Wri

6、tableFont.BOLD, false); jxl.write.WritableCellFormat wcfFC1 = new jxl.write.WritableCellFormat(wfc1); /水平居中wcfFC1.setAlignment(jxl.format.Alignment.CENTRE); /垂直居中wcfFC1.setVerticalAlignment(jxl.format.VerticalAlignment.CENTRE); /边框wcfFC1.setBorder(Border.ALL, BorderLineStyle.THIN);String title = 序号,

7、时间,源IP地址,目标IP地址,源MAC地址,目标MAC地址,错误信息;String splitsTitle = title.split(,);int length = splitsTitle.length;for (int i = 0; i length; i+) sheet.addCell(new jxl.write.Label(i,0,splitsTitlei,wcfFC1);/ 设置单元格的宽度 sheet.setColumnView(0, 5); sheet.setColumnView(1, 20); sheet.setColumnView(2, 15); sheet.setColu

8、mnView(3, 15); sheet.setColumnView(4, 20); sheet.setColumnView(5, 20);sheet.setColumnView(6, 15); jxl.write.WritableFont wfc2 = new jxl.write.WritableFont(WritableFont.ARIAL,10,WritableFont.NO_BOLD,false);jxl.write.WritableCellFormat wcfFC2 = new jxl.write.WritableCellFormat(wfc2);wcfFC2.setAlignmen

9、t(jxl.format.Alignment.CENTRE);wcfFC2.setVerticalAlignment(jxl.format.VerticalAlignment.CENTRE);wcfFC2.setBorder(Border.ALL, BorderLineStyle.THIN);/数据int c = 1;String sqlStr = select w_data,ip_src,ip_tar,mac_src,mac_tar,wtype from wmsg where 1=1 ;List list = auditMDao.getRsBySql(sqlStr);for (int i =

10、 0; i list.size(); i+) Object msg = (Object) list.get(i);String date = msg0.toString();String ip_src = msg1.toString();String ip_tar = msg2.toString();String mac_src = msg3.toString();String mac_tar = msg4.toString();String wtype = msg5.toString();Label content1 = new Label(0,c,c+,wcfFC2);Label cont

11、ent2 = new Label(1,c,date,wcfFC2);Label content3 = new Label(2,c,ip_src,wcfFC2);Label content4 = new Label(3,c,ip_tar,wcfFC2);Label content5 = new Label(4,c,mac_src,wcfFC2);Label content6 = new Label(5,c,mac_tar,wcfFC2);Label content7 = new Label(6,c,wtype,wcfFC2);sheet.addCell(content1);sheet.addCell(content2);sheet.addCell(c