jxl页面导出excel函数

最新推荐文章于 2020-03-18 11:05:08 发布

原创最新推荐文章于 2020-03-18 11:05:08 发布 · 726 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#excel #exception #filter #string #os

Java 学习笔记专栏收录该内容

33 篇文章

订阅专栏

本文介绍了一种差旅费用报表的自动化生成方法，通过Java编程实现从数据库获取差旅信息，利用Apache POI库创建Excel文件，展示了一个完整的差旅费用报表生成流程。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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();
        }
    }