基于easyexcel做导入

最新推荐文章于 2024-11-21 16:24:45 发布

lemonmr

最新推荐文章于 2024-11-21 16:24:45 发布

阅读量845

点赞数 2

本文链接：https://blog.youkuaiyun.com/lemonmr/article/details/103593287

版权

准备工作:
1.一个excel文件如下图
excel
2.项目中带入maven

<dependency>
    <groupId>org.apache.poi</groupId>
    <artifactId>poi</artifactId>
    <version>3.17</version>
</dependency>
<!--xlsx格式excel依赖包-->
<dependency>
    <groupId>org.apache.poi</groupId>
    <artifactId>poi-ooxml</artifactId>
    <version>3.17</version>
</dependency>
<!-- easyexcel依赖包 -->
<dependency>
    <groupId>com.alibaba</groupId>
    <artifactId>easyexcel</artifactId>
    <version>1.1.2-beat1</version>
</dependency>

具体操作步骤如下:

1.新建实体类 --用于接收excel中的数据

import com.alibaba.excel.annotation.ExcelProperty; 
import com.alibaba.excel.metadata.BaseRowModel;

public class Catagory extends BaseRowModel {
   
    @ExcelProperty(value = "id", index = 0)
    private Integer id;

    @ExcelProperty(value = "name", index = 1)
    private String name;

    @Override
    public String toString() {
   
        return "Catagory{" +
                "id=" + id +
                ", name='" + name + '\'' +
                '}';
    }

    public Catagory() {