EasyExcel使用

泠梧

已于 2023-04-20 14:53:13 修改

阅读量386

点赞数

文章标签： java 大数据数据库

于 2023-04-20 14:51:32 首次发布

本文链接：https://blog.csdn.net/cyh0107/article/details/130266011

版权

文章介绍了如何在Java中使用EasyExcel和ApachePOI库来处理Excel文件，包括添加依赖、写入数据到Excel、创建工作表以及设置表头信息。还提到了泛型使用时的注意事项，并展示了如何实现单元格的合并策略。

摘要由CSDN通过智能技术生成

一.依赖引用

<!-- poi -->
        <dependency>
            <groupId>org.apache.poi</groupId>
            <artifactId>poi-ooxml</artifactId>
            <version>4.1.2</version>
        </dependency>
        <dependency>
        <dependency>
            <groupId>org.apache.poi</groupId>
            <artifactId>poi</artifactId>
            <version>4.1.2</version>
            <scope>compile</scope>
        </dependency>
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>easyexcel</artifactId>
            <version>2.2.6</version>
            <scope>compile</scope>
        </dependency>
        <dependency>
            <groupId>org.apache.poi</groupId>
            <artifactId>poi-ooxml-schemas</artifactId>
            <version>4.1.2</version>
            <scope>compile</scope>
        </dependency>

二.使用详情

String filename = "";
ExcelWriter excelWriter = EasyExcel.write(filename).build();

filename为生成Excel路径

WriteSheet sheet = EasyExcel.writerSheet(index, sheetName)
                .head(Data.class).build();

创建一个新sheet，sheet索引为index（0开始），名称sheetName

Data.class为生成数据的类型

@ExcelProperty(value = "表头名称",index = 0)

Pojo类属性上添加EasyExcel注解，value为表头信息，index为第几列（0开始）

excelWriter.write(list, sheet);

list为数据列表，类型为Data.class

注意：泛型可能无法识别，导致列表头信息报错

    public static void main(String[] args) {
        write(Pv.class);
    }

    public static <T> void write(T tClass){
        String filename = "/Users/admin/Documents/ccc111.xlsx";
        List<Pv> list = new ArrayList<>();
        Pv pv = new Pv();
        pv.setDate("123");
        pv.setDomestic(12);
        list.add(pv);
        ExcelWriter excelWriter = EasyExcel.write(filename).build();
        WriteSheet sheet = EasyExcel.writerSheet(0, "s1")
                .head(tClass.getClass()).build();
        excelWriter.write(list, sheet);
//        WriteSheet sheet1 = EasyExcel.writerSheet(1, "s2")
//                .head(Pv.class).build();
//        excelWriter.write(list, sheet1);
        excelWriter.finish();
    }

这样不会报错

    public static void main(String[] args) {
        write(Pv.class);
    }

    public static <T> void write(Class<T> tClass){
        String filename = "/Users/admin/Documents/ccc111.xlsx";
        List<Pv> list = new ArrayList<>();
        Pv pv = new Pv();
        pv.setDate("123");
        pv.setDomestic(12);
        list.add(pv);
        ExcelWriter excelWriter = EasyExcel.write(filename).build();
        WriteSheet sheet = EasyExcel.writerSheet(0, "s1")
                .head(tClass).build();
        excelWriter.write(list, sheet);
//        WriteSheet sheet1 = EasyExcel.writerSheet(1, "s2")
//                .head(Pv.class).build();
//        excelWriter.write(list, sheet1);
        excelWriter.finish();
    }