SpringBoot之导入导出Excel工具类自定义封装（Java8实现）待完善

1，添加poi依赖

<properties>
    <org.apache.poi.ooxml.version>3.13</org.apache.poi.ooxml.version>
</properties>

<dependencies>
    <dependency>
        <groupId>org.apache.poi</groupId>
        <artifactId>poi-ooxml</artifactId>
        <version>${org.apache.poi.ooxml.version}</version>
    </dependency>
    <dependency>
        <groupId>org.apache.poi</groupId>
        <artifactId>poi</artifactId>
        <version>${org.apache.poi.ooxml.version}</version>
    </dependency>
</dependencies>

2，自定义表格注解

@Target({ElementType.FIELD})
@Retention(RetentionPolicy.RUNTIME)
@Documented
public @interface ExcelColumn {

    String value() default "";

    int col() default 0;
}

3，ExcelUtils编写

public class ExcelUtils {
    
    /**
     * 导出excel
     */
    public static <T> Resource writeExcel(List<T> dataList, Class<T> cls) throws IOException {
        return writeExcel(dataList, cls, 100);
    }

    /**
     * 导出excel
     */
    public static <T> Resource writeExcel(List<T> dataList, Class<T> cls, Integer splitCount) throws IOException {
        Field[] fields = cls.getDeclaredFields();
        List<Field> fieldList = Arrays.stream(fi