javawebsshjxl导出Excel实例.docxVIP

JavaWeb SSH JXL导出ExcelJsp:input type=button class=d-button d-state-highlight onclick=aaa() id=exportExcel value=导出Excelfunction aaa() {// 提交方式一定不能为ajax，否则不会出现保存对话框var frm=document.getElementById(searchwmsgform);frm.action=%=web%/select.do?dispatch=exportExcel;frm.submit();}Action：/***导出Excel*@parammapping*@paramform*@paramrequest*@paramresponse*@return*/public ActionForward exportExcel(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 {//创建一个缓冲输入流对象BufferedInputStream br = new BufferedInputStream( new FileInputStream(file)); byte[] buf = newbyte[1024]; int len = 0; response.reset(); // 非常重要response.setContentType(application/x-msdownload); response.setHeader(Content-Disposition, attachment; filename= + new String(file.getName().getBytes(),iso-8859-1));//创建输出流对象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.delete(); } } catch (Exception e) {// TODO Auto-generated catch blocke.printStackTrace();}returnnull;}实现类中：publicvoid exportExcel(WritableWorkbook book) throws Exception {try {WritableSheet sheet = book.createSheet(第一页, 0);//字段字体jxl.write.WritableFont wfc1 = new jxl.write.WritableFont( WritableFont.ARIAL, 13, WritableFont.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 = 序号,时间,源IP地址,目标IP地址,源MAC地址,目标MAC地址,错误信息;String[] splitsTitle = title.