EasyExcel

1. 简介

EasyExcel是一个基于Java的、快速、简洁、解决大文件内存溢出的Excel处理工具。

2. 添加依赖

<dependency>
    <groupId>com.alibaba</groupId>
    <artifactId>easyexcel</artifactId>
    <version>4.0.3</version>
</dependency>

3. 读操作

public class EasyExcelRead {
    static Logger logger = LoggerFactory.getLogger(EasyExcelRead.class);

    public static void main(String[] args) throws IOException {
        String filePath = "D:\\07excelData.xlsx";
        ObjectMapper objectMapper = new ObjectMapper();
        EasyExcel.read(filePath, DemoData.class, new PageReadListener<DemoData>(dataList -> {
            for (DemoData demoData : dataList) {
                try {
                    String jsonStr = objectMapper.writeValueAsString(demoData);
                    logger.info("读取到一条数据{}", jsonStr);
                } catch (JsonProcessingException e) {
                    throw new RuntimeException(e);
                }
            }
        })).sheet().doRead();
    }

    public static class DemoData {
        private double id;
        private String name;

        public double getId() {
            return id;
        }

        public void setId(double id) {
            this.id = id;
        }

        public String getName() {
            return name;
        }

        public void setName(String name) {
            this.name = name;
        }
    }
}

运行结果：

4. 写操作