利用jxl将数据导出到excel时弹出保存对话框的例子
public String outPutExcel(ModelMap model, HttpServletRequest request, HttpServletResponse response) { //获取时间区域 String timeArea = request.getParameter("timeArea"); String keyword = request.getParameter("keyword"); String select = request.getParameter("select"); //获取操作类型 String operate = request.getParameter("operate"); // File file = new File("daily.xls"); try { OutputStream os = response.getOutputStream();// 取得输出流 response.reset();// 清空输出流 response.setHeader("Content-disposition", "attachment; filename=" + new String("daily".getBytes("GB2312"), "iso8859_1") + ".xls");// 设定输出文件头 response.setContentType("application/msexcel");// 定义输出类型 WritableWorkbook workbook = Workbook.createWorkbook(os); if (workbook != null) { WritableSheet sheet = workbook.createSheet("sheet1", 0); // 设置标题 sheet.addCell(new jxl.write.Label(列(从0开始), 行(从0开始), 内容.)); try { sheet.addCell(new Label(0, 0, "区域名")); sheet.addCell(new Label(1, 0, "所在位置")); sheet.addCell(new Label(2, 0, "操作人员")); sheet.addCell(new Label(3, 0, "时间")); sheet.addCell(new Label(4, 0, "操作类型")); sheet.addCell(new Label(5, 0, "备注")); // 设置单元格的宽度 sheet.setColumnView(0, 20); sheet.setColumnView(1, 40); sheet.setColumnView(2, 15); sheet.setColumnView(3, 30); sheet.setColumnView(4, 15); sheet.setColumnView(5, 20); //添加数据 List<SysActionLog> list = this.getSysActionLogs(timeArea, keyword, select, operate); SysActionLog log = null; for (int r = 0; r < list.size(); r++) { //行编号 log = list.get(r); //区域名 sheet.addCell(new Label(0, r + 1, log.getFilealia())); //所在位置 sheet.addCell(new Label(1, r + 1, log.getFilename())); //操作人员 sheet.addCell(new Label(2, r + 1, log.getAuthor())); //时间 sheet.addCell(new Label(3, r + 1, log.getFormatDate())); //操作类型 sheet.addCell(new Label(4, r + 1, log.getSysAction().getMessage())); //备注 sheet.addCell(new Label(5, r + 1, log.getComment())); } //从内存中写入文件中 workbook.write(); //关闭资源，释放内存 workbook.close(); /*response.reset(); FileInputStream f = new FileInputStream(file); byte[] fb = new byte[f.available()]; f.read(fb); response .setHeader("Content-disposition", "attachment; filename=" + new String("daily.xls" .getBytes("gb2312"), "iso8859-1")); ByteArrayInputStream bais = new ByteArrayInputStream(fb); int b; while ((b = bais.read()) != -1) { response.getOutputStream().write(b); } response.getOutputStream().flush(); //删除服务器上的文件 file.deleteOnExit();*/ } catch (RowsExceededException e) { logger.error("sheet不存在", e); } catch (WriteException e) { logger.error("创建列名出错", e); } } } catch (IOException e) { logger.error("文件创建出错", e); } return "daily.vm"; }?