jxl页面导出excel函数

 1、
  private InputStream excelStream;

2、

 public InputStream getExcelStream() {
  return excelStream;
 }

3、
 public String travelExport() throws Exception {
  excelStream = getExcelInputStream();
  return SUCCESS;
 }
 
 private InputStream getExcelInputStream() {   
        //将OutputStream转化为InputStream   
        ByteArrayOutputStream out = new ByteArrayOutputStream();   
        putDataOnOutputStream(out);   
        return new ByteArrayInputStream(out.toByteArray());   
    }
 
 private void putDataOnOutputStream(OutputStream os) {   
        try {   
         WritableWorkbook workbook = Workbook.createWorkbook(os);
            WritableSheet sheet = workbook.createSheet("差旅费", 0);
            WritableFont arial10font = new WritableFont(WritableFont.ARIAL, 10);
            arial10font.setBoldStyle(WritableFont.BOLD);
            WritableCellFormat arial10format = new WritableCellFormat (arial10font);
            arial10format.setBackground(Colour.GRAY_50);
            int row = 0;
         sheet.addCell(new Label(0, row, "日期", arial10format));
         sheet.addCell(new Label(1, row, "摘要", arial10format));
         sheet.addCell(new Label(2, row, "金额", arial10format));
         sheet.addCell(new Label(3, row, "姓名", arial10format));
         sheet.addCell(new Label(4, row, "付款方式", arial10format));
         sheet.addCell(new Label(5, row, "备注", arial10format));
         //设置列的宽度
         for (int i = 0; i < 6; i++) {
          sheet.setColumnView(i, 20);
   }
         
         NumberFormat format = new NumberFormat("#.##");
         WritableCellFormat moneyFormat = new WritableCellFormat(format);
         
            FilterInfo filter = new FilterInfo();
            filter.rules = new RuleInfo[0];
            int totalCount = erpService.getTravelCount(filter);
            List<TravelInfoWrapper> travels = erpService.getTravels(1, totalCount, filter);
            for (int i = 0; i < totalCount; i++) {
             row = i + 1;
             TravelInfoWrapper travel = travels.get(i);
             sheet.addCell(new Label(0, row, travel.getRecodeDate()));
             sheet.addCell(new Label(1, row, travel.getSummary()));
             sheet.addCell(new jxl.write.Number(2, row, travel.getMoney(), moneyFormat));
             sheet.addCell(new Label(3, row, travel.getUserName()));
             sheet.addCell(new Label(4, row, travel.getPayment()));
             sheet.addCell(new Label(5, row, travel.getNote()));
   }
            workbook.write();   
            workbook.close();   
        } catch (Exception e) {   
            e.printStackTrace();   
        }   
    }