SpringBoot+POI 实现导出Excel文件

最新推荐文章于 2024-08-14 09:40:46 发布

默默努力的Boy

最新推荐文章于 2024-08-14 09:40:46 发布

阅读量650

点赞数

分类专栏： Poi 文章标签： poi excel java

本文链接：https://blog.csdn.net/weixin_43682921/article/details/105183711

版权

之前用的easyPoi 导出过程中 一直报错 因为项目比较急 索性就直接不用
**第一步   引用POM文件**
 <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>
**第二步 调用两个工具类**

public class ExcelBean {
   
    public ExcelBean() {
   
    }

    public ExcelBean(int sheetNum, String sheetTitle, String[] headers, List<List<String>> data) {
   
        this.sheetNum = sheetNum;
        this.sheetTitle = sheetTitle;
        this.headers = headers;
        this.data = data;
    }

    private int                sheetNum;

    private String             sheetTitle;

    private String[]           headers;

    private List<List<String>> data;

    public int getSheetNum() {
   
        return sheetNum;
    }

    public void setSheetNum(int sheetNum) {
   
        this.sheetNum = sheetNum;
    }

    public String getSheetTitle() {
   
        return sheetTitle;
    }

    public void setSheetTitle(String sheetTitle)