EasyExcel读取Excel简单Demo

蔚落 2022-10-17 00:39 188阅读 0赞

### 目录 ###

*  Maven
 *  Excel
 *  DemoData
 *  DemoDataListener
 *  DemoMain
 *  执行结果

# Maven #

<dependency>
        <groupId>com.alibaba</groupId>
        <artifactId>easyexcel</artifactId>
        <version>2.2.10</version>
    </dependency>
    <dependency>
        <groupId>org.projectlombok</groupId>
        <artifactId>lombok</artifactId>
        <version>1.18.20</version>
    </dependency>
    <dependency>
        <groupId>com.alibaba</groupId>
        <artifactId>fastjson</artifactId>
        <version>1.2.76</version>
    </dependency>

# Excel #

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzMzMjQ3NDM1_size_16_color_FFFFFF_t_70]

# DemoData #

package com.demo.test.easyExcel;
    
    import com.alibaba.excel.annotation.ExcelProperty;
    import com.alibaba.excel.annotation.format.DateTimeFormat;
    import com.alibaba.excel.annotation.format.NumberFormat;
    
    /** * 数据实体类 * * @author zhao.hualuo * Create at 2021/5/31 */
    @lombok.Data
    public class DemoData { 
    
        @ExcelProperty("字符串标题")
        private String string;
    
        @ExcelProperty("日期标题")
        @DateTimeFormat("yyyy年MM月dd日")
        private String dateStr;
    
        @ExcelProperty("数字标题")
        @NumberFormat("#.##%")
        private String doubleData;
    }

# DemoDataListener #

package com.demo.test.easyExcel;
    
    import com.alibaba.excel.context.AnalysisContext;
    import com.alibaba.excel.event.AnalysisEventListener;
    import com.alibaba.fastjson.JSON;
    import com.alibaba.fastjson.JSONObject;
    import org.slf4j.Logger;
    import org.slf4j.LoggerFactory;
    
    /** * 监听器 * DemoDataListener 不能被spring管理，要每次读取excel都要new,然后里面用到spring可以构造方法传进去 * * @author zhao.hualuo * Create at 2021/5/31 */
    public class DemoDataListener extends AnalysisEventListener { 
    
        private static final Logger LOGGER = LoggerFactory.getLogger(DemoDataListener.class);
    
        int index = 0;
    
        /** * 每一条数据解析都会调用 */
        @Override
        public void invoke(Object object, AnalysisContext context) { 
            DemoData demoData = JSONObject.parseObject(JSON.toJSONString(object), DemoData.class);
            //进行业务逻辑处理
            index ++;
            LOGGER.info("解析到一条数据{}:{}", index, demoData.toString());
        }
    
        /** * 所有数据解析完成之后 会来调用这一个 */
        @Override
        public void doAfterAllAnalysed(AnalysisContext analysisContext) { 
            //收尾工作
            LOGGER.info("所有数据解析完成！" + index);
        }
    
    }

# DemoMain #

package com.demo.test.easyExcel;
    
    import com.alibaba.excel.EasyExcel;
    
    /** * 执行主函数 * * @author zhao.hualuo * Create at 2021/5/31 */
    public class DemoMain { 
    
        public static void main(String[] args) { 
            String fileName = "D:\\Documents\\person\\zhao.hualuo\\桌面\\demo.xlsx";
            EasyExcel.read(fileName, DemoData.class,new DemoDataListener()).sheet().doRead();
        }
    }

# 执行结果 #

> 15:33:32.070 \[main\] INFO com.demo.test.easyExcel.DemoDataListener - 解析到一条数据1:DemoData(string=aaa, dateStr=2020年01月01日, doubleData=100%)  
> 15:33:32.072 \[main\] INFO com.demo.test.easyExcel.DemoDataListener - 解析到一条数据2:DemoData(string=bbb, dateStr=2020年01月02日, doubleData=200%)  
> 15:33:32.073 \[main\] INFO com.demo.test.easyExcel.DemoDataListener - 解析到一条数据3:DemoData(string=ccc, dateStr=2020年01月03日, doubleData=300%)  
> 15:33:32.075 \[main\] INFO com.demo.test.easyExcel.DemoDataListener - 解析到一条数据4:DemoData(string=ddd, dateStr=2020年01月04日, doubleData=400%)  
> 15:33:32.077 \[main\] INFO com.demo.test.easyExcel.DemoDataListener - 解析到一条数据5:DemoData(string=eee, dateStr=2020年01月05日, doubleData=500%)  
> 15:33:32.078 \[main\] INFO com.demo.test.easyExcel.DemoDataListener - 解析到一条数据6:DemoData(string=fff, dateStr=2020年01月06日, doubleData=600%)  
> 15:33:32.081 \[main\] INFO com.demo.test.easyExcel.DemoDataListener - 解析到一条数据7:DemoData(string=ggg, dateStr=2020年01月07日, doubleData=700%)  
> 15:33:32.083 \[main\] INFO com.demo.test.easyExcel.DemoDataListener - 解析到一条数据8:DemoData(string=hhh, dateStr=2020年01月08日, doubleData=800%)  
> 15:33:32.083 \[main\] INFO com.demo.test.easyExcel.DemoDataListener - 解析到一条数据9:DemoData(string=iii, dateStr=2020年01月09日, doubleData=900%)  
> 15:33:32.084 \[main\] INFO com.demo.test.easyExcel.DemoDataListener - 解析到一条数据10:DemoData(string=jjj, dateStr=2020年01月10日, doubleData=1000%)  
> 15:33:32.085 \[main\] INFO com.demo.test.easyExcel.DemoDataListener - 所有数据解析完成！10

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzMzMjQ3NDM1_size_16_color_FFFFFF_t_70]: /images/20221014/2ef37a7ff6ee406b8ddf2d1a5c92deee.png