阿里easyexcel教程

最新推荐文章于 2024-08-03 20:59:19 发布

波波老师

最新推荐文章于 2024-08-03 20:59:19 发布

阅读量836

点赞数

分类专栏： Java生态文章标签： excel 阿里巴巴 java

本文链接：https://blog.csdn.net/xl_1803/article/details/107745764

版权

Java生态专栏收录该内容

54 篇文章 5 订阅

订阅专栏

1、引入依赖

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

2、ExcelUtil

import com.alibaba.excel.EasyExcel;
import com.alibaba.excel.read.listener.ReadListener;

import java.util.List;


public class ExcelUtil {

    public static void readToListener(String excelPath, Class<?> clazz, ReadListener readListener){
        EasyExcel.read(excelPath, clazz, readListener).sheet().doRead();
    }

    public static void write(String excelPath, Class<?> clazz, List<?> data,String sheetName){
        EasyExcel.write(excelPath, clazz).sheet(sheetName).doWrite(data);
    }

    public static void writeDynamicHead(String excelPath,List<List<String>> head,String sheetName,List<List<String>> data) {

        EasyExcel.write(excelPath).head(head).sheet(sheetName).doWrite(data);
    }


}