首先引入poi相关依赖包
<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>
<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi-ooxml-schemas</artifactId>
<version>3.17</version>
</dependency>
然后编写代码
package com.match.easyExcel;
import org.apache.poi.hssf.usermodel.*;
import org.springframework.stereotype.Component;
import java.io.FileInputStream;
import java.text.SimpleDateFormat;
import java.util.*;
/**
* @aut