Java读取本地Excel文件

一、引入依赖包

        <dependency>
            <groupId>cn.afterturn</groupId>
            <artifactId>easypoi-spring-boot-starter</artifactId>
            <version>4.2.0</version>
        </dependency>
        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
            <version>1.18.24</version>
        </dependency>

二、编写实体类 

@Data
@ToString
public class User {
    //@Excel使属性与列名对应
    @Excel(name = "姓名", width = 15)
    private String name;
    @Excel(name = "年龄", width = 15)
    private int age;
}

三、找到本地文件

三、编写测试类

public class Test2 {
    public static void main(String[] args) {
        try {
          //找到本地文件
            FileInputStream fileInputStream = new FileInputStream("E:\\aa\\User.xls");
           //读取参数
            ImportParams importParams = new ImportParams();
           //读取本地文件
            List<Object> userList = ExcelImportUtil.importExcel(fileInputStream, User.class, importParams);
           //打印到控制台
            System.out.println(userList);
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}

四、结果