jxl 导出excle

WritableWorkbook book = Workbook.createWorkbook(response
    .getOutputStream());
  WritableSheet sheet = book.createSheet("交办卡片", 0);
  try {
   WritableFont rFont = new WritableFont(WritableFont.ARIAL, 14,
     WritableFont.BOLD, false, UnderlineStyle.NO_UNDERLINE,
     Colour.BLACK);
   WritableCellFormat rCellFormat = new WritableCellFormat(rFont);
   rCellFormat.setAlignment(Alignment.CENTRE);
   rCellFormat.setVerticalAlignment(VerticalAlignment.CENTRE);
   rCellFormat.setBorder(Border.ALL, BorderLineStyle.THIN);

   WritableFont conFont = new WritableFont(WritableFont.ARIAL, 12,
     WritableFont.NO_BOLD, false, UnderlineStyle.NO_UNDERLINE,
     Colour.BLACK);
   WritableCellFormat conCellFormat = new WritableCellFormat(conFont);
   conCellFormat.setAlignment(Alignment.CENTRE);
   conCellFormat.setBorder(Border.ALL, BorderLineStyle.THIN);

   Label wlabels = new Label(0, 0, "文号", conCellFormat);
   sheet.addCell(wlabels);
   wlabels = new Label(1, 0, "来文机关", conCellFormat);
   sheet.addCell(wlabels);
   wlabels = new Label(2, 0, "文件内容", conCellFormat);
   sheet.addCell(wlabels);
   wlabels = new Label(3, 0, "交办时间", conCellFormat);
   sheet.addCell(wlabels);
   wlabels = new Label(4, 0, "办结时间", conCellFormat);
   sheet.addCell(wlabels);
   wlabels = new Label(5, 0, "主办处室", conCellFormat);
   sheet.addCell(wlabels);
   wlabels = new Label(6, 0, "会办处室", conCellFormat);
   sheet.addCell(wlabels);
   wlabels = new Label(7, 0, "办理情况", conCellFormat);
   sheet.addCell(wlabels);
   wlabels = new Label(8, 0, "领导批示", conCellFormat);
   sheet.addCell(wlabels);

   for (int i = 0; i < typeV.size(); ++i) {
    Map map = (HashMap) typeV.get(i);
    wlabels = new Label(0, 1 + i, (String) map.get("BH"),
      conCellFormat);
    sheet.addCell(wlabels);
    wlabels = new Label(1, 1 + i, (String) map.get("JBK_LWJG"),
      conCellFormat);
    sheet.addCell(wlabels);
    wlabels = new Label(2, 1 + i, (String) map.get("TITLE"),
      conCellFormat);
    sheet.addCell(wlabels);
    wlabels = new Label(3, 1 + i, (String) map.get("JBK_JBRQ"),
      conCellFormat);
    sheet.addCell(wlabels);
    wlabels = new Label(4, 1 + i, (String) map.get("JBK_BJRQ"),
      conCellFormat);
    sheet.addCell(wlabels);
    wlabels = new Label(5, 1 + i, (String) map.get(""),
      conCellFormat);
    sheet.addCell(wlabels);
    wlabels = new Label(6, 1 + i, (String) map.get(""),
      conCellFormat);
    sheet.addCell(wlabels);

    wlabels = new Label(7, 1 + i, "end".equals(((String) map.get("CURNODE")))?"已办结":"未办结",         //判断是end的时候，为已办结。其余的为未办结
      conCellFormat);
    sheet.addCell(wlabels);
    wlabels = new Label(8, 1 + i, (String) map.get("JBK_LDPS"),
      conCellFormat);
    sheet.addCell(wlabels);
   }

   book.write();
   response.setContentType("aplication/msexcel");
   String fileName = "交办卡片";
   fileName = URLEncoder.encode(fileName, "utf-8");
   response.setHeader("Content-disposition", "attachment; filename="
     + fileName + ".xls");
  } catch (Exception e) {
   e.printStackTrace();
  } finally {
   try {
    book.close();
   } catch (WriteException e) {
    // TODO Auto-generated catch block
    e.printStackTrace();
   }
  }
  return null;
 }