Spring boot结合easy excel实现低代码量的Excel导入导出

在Spring Boot中，结合easyexcel库实现Excel的导入导出可以通过以下步骤进行：

1. 添加easyexcel依赖到你的Spring Boot项目的pom.xml文件中。

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

2. 创建对应Excel数据的实体类。

import com.alibaba.excel.annotation.ExcelProperty;
 
public class ExcelData {
    @ExcelProperty("姓名")
    private String name;
 
    @ExcelProperty("年龄")
    private int age;
 
    // 省略getter和setter方法
}

3. 创建导入导出的工具类。

导出工具类：

import com.alibaba.excel.EasyExcel;
 
import java.util.List;
 
public class ExcelExportUtil {
    public void exportExcel(List<ExcelData> data, String fileName) {
        EasyExcel.write(fileName, ExcelData.class).sheet("数据").doWrite(data);
    }
}

导入工具类：

import com.alibaba.excel.EasyExcel;
import com.alibaba.excel.read.listener.ReadListener;
import com.alibaba.excel.context.AnalysisContext;
import com.alibaba.excel.event.AnalysisEventListener;
 
import java.util.ArrayList;
import java.util.List;
 
public class ExcelImportUtil {
    public List<ExcelData> importExcel(String fileName) {
        List<ExcelData> list = new ArrayList<>();
        EasyExcel.read(fileName, ExcelData.class, new ReadListener<ExcelData>() {
            @Override
            public void invoke(ExcelData data, AnalysisContext context) {
                list.add(data);
            }
 
            @Override
            public void doAfterAllAnalysed(AnalysisContext context) {
            }
        }).sheet().doRead();
 
        return list;
    }
}

4. 在Spring Boot的Controller中使用导入导出工具类。

import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.RestController;
import org.springframework.web.multipart.MultipartFile;
 
import java.util.List;
 
@RestController
public class ExcelController {
 
    private final ExcelExportUtil excelExportUtil;
    private final ExcelImportUtil excelImportUtil;
 
    public ExcelController(ExcelExportUtil excelExportUtil, ExcelImportUtil excelImportUtil) {
        this.excelExportUtil = excelExportUtil;
        this.excelImportUtil = excelImportUtil;
    }
 
    @PostMapping("/export")
    public void exportExcel() {
        List<ExcelData> data = // ... 获取数据源
        excelExportUtil.exportExcel(data, "exported.xlsx");
    }
 
    @PostMapping("/import")
    publi