小狼-easy-Poi百万数据导出

最新推荐文章于 2024-04-26 11:18:43 发布

咱是汝的什么

最新推荐文章于 2024-04-26 11:18:43 发布

阅读量229

点赞数 1

本文链接：https://blog.csdn.net/qq_44729800/article/details/119793859

版权

EasyPoi 大数据 Excel导出批量处理内存管理

关键词由CSDN通过智能技术生成

首先贴出文档：EasyPoi教程_V1.0 (mydoc.io)

其次：代码：

@Test
public void bigDataExport() throws Exception {
    List<MsgClient> list = new ArrayList<>();
    Workbook workbook = null;
    Date start = new Date();
    ExportParams params = new ExportParams("大数据测试", "测试");
    for (int i = 0; i < 1000000; i++) {  //一百万数据量
        MsgClient client = new MsgClient();
        client.setBirthday(new Date());
        client.setClientName("小明" + i);
        client.setClientPhone("18797" + i);
        client.setCreateBy("JueYue");
        client.setId("1" + i);
        client.setRemark("测试" + i);
        list.add(client);
        if (list.size() == 10000) {
            workbook = ExcelExportUtil.exportBigExcel(params, MsgClient.class, list);
            list.clear();
        }
    }
    // ExcelExportUtil.exportExcel(params, MsgClient.class, list);
    ExcelExportUtil.closeExportBigExcel();
    File savefile = new File("D:/excel/");
    if (!savefile.exists()) {
        savefile.mkdirs();
    }
    FileOutputStream fos = new FileOutputStream("D:/excel/bigExcel.xlsx");
    workbook.write(fos);
    fos.close();
    System.out.println(new Date().getTime() - start.getTime());
}