Java列表数据导出Excel 详解

Java列表数据导出Excel 详解

1.导包

  <!-- https://mvnrepository.com/artifact/com.alibaba/easyexcel -->
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>easyexcel</artifactId>
            <version>2.1.4</version>
        </dependency>
        <!--xls-->
        <dependency>
            <groupId>org.apache.poi</groupId>
            <artifactId>poi</artifactId>
            <version>3.17</version>
        </dependency>
        <dependency>
            <groupId>org.apache.poi</groupId>
            <artifactId>poi-ooxml</artifactId>
            <version>3.17</version>
        </dependency>

2.配置类

来源:https://www.cnblogs.com/JWMA/p/12768166.html

/**
 * @author
 * @version 1.0
 * @date 2021/6/18 15:39
 * ** 来源： https://www.cnblogs.com/JWMA/p/12768166.html
 */
@Slf4j
public class EasyExcelUtil {
   
    private static final String XLS_VAL = ".xls";
    private static final String XLS_X_VAL = ".xlsx";


    /**
     * 无模板写文件
     *
     * @param filePath
     * @param head     表头数据
     * @param data     表内容数据
     */
    public static void write(String filePath, List<List<String>> head, List<List<Object>> data) {
   
        EasyExcel.write(filePath).head(head).sheet().doWrite(data)