【备忘录】easyExcel DEMO

最新推荐文章于 2023-07-13 09:54:33 发布

the_fool_

最新推荐文章于 2023-07-13 09:54:33 发布

阅读量182

点赞数 4

本文链接：https://blog.csdn.net/the_fool_/article/details/114922792

版权

自用备忘录文档，学习请转至官网或git

依赖

    <!-- easy excel -->
            <dependency>
                <groupId>com.alibaba</groupId>
                <artifactId>easyexcel</artifactId>
                <version>2.2.6</version>
            </dependency>

  private String demo( String expFileFullPath) throws Exception{
        // 准备文件
        File file = new File(expFileFullPath);
        // 写入文件内容
        ExcelWriter excelWriter = null;
        try (InputStream templateIs = new ClassPathResource(OUTPUT_FILE_PATH).getInputStream()) {
            excelWriter = EasyExcel.write(file).withTemplate(templateIs).build();

            // 写入各 sheet 数据
            List<AlipayClassifyResultClassifyType> classifyTypes = getAllHotelDetailBillType();
            for (AlipayClassifyResultClassifyType classifyType : classifyTypes) {

                WriteSheet sheet = EasyExcel.writerSheet(classifyType.getDesc()).build();
                boolean haveData = false;
                for (int offset = 0, count = 1000; ; offset += count) {
                    List<StoreItemBillDetail> results = detailMapper.listByType(type,,offset,count);

                    if (results.size() > 0) {
                        haveData=true;
                        excelWriter.fill(results, sheet);
                    }
                    if (results.size() < count) {
                        break;
                    }
                }
                if(!haveData){
                    List<StoreItemBillDetail> results = new ArrayList<>();
                    excelWriter.fill(results, sheet);
                }
            }
        } catch (Exception e) {
            LOGGER.error("demo Exception",e);
            throw e;
        } finally {
            if (excelWriter != null) {
                excelWriter.finish();
            }
        }