java实现Excel的导入导出

最近遇到了这么一个功能，要实现Excel文件的导入导出功能，下面直接上代码好了：

项目目录图：

导入导出主要使用了这三个pom依赖：

    <!-- 导入导出 -->
        <dependency>
            <groupId>cn.afterturn</groupId>
            <artifactId>easypoi-base</artifactId>
            <version>3.0.3</version>
        </dependency>
        <dependency>
            <groupId>cn.afterturn</groupId>
            <artifactId>easypoi-web</artifactId>
            <version>3.0.3</version>
        </dependency>
        <dependency>
            <groupId>cn.afterturn</groupId>
            <artifactId>easypoi-annotation</artifactId>
            <version>3.0.3</version>
        </dependency>
        <dependency>
            <groupId>cn.afterturn</groupId>
            <artifactId>easypoi-spring-boot-starter</artifactId>
            <version>4.0.0</version>
        </dependency>

yml配置

#配置数据源
spring:
  datasource:
    driver-class-name: com.mysql.cj.jdbc.Driver
    url: jdbc:mysql://localhost:3306/mybatisplus?useUnicode=true&characterEncoding=UTF-8&serverTimezone=GMT%2B8&
    username: root
    password: root
  main:
    allow-bean-definition-overriding: on

#指定mybatis映射文件的地址
mybatis:
  mapper-locations: classpath:mapper/*.xml

UserController 代码：

package easypoi.controller;

import easypoi.entity.User;
import easypoi.service.UserService;
import easypoi.utils.ExcelUtils;
import org.springframework.beans.factory.annotation.Autowired