1.在pom引入jra包
<!--导入导出excel-->
<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi-ooxml</artifactId>
<version>3.15</version>
<exclusions>
<exclusion>
<groupId>stax</groupId>
<artifactId>stax-api</artifactId>
</exclusion>
</exclusions>
</dependency>
2.导出模板(util文件)
import lombok.extern.slf4j.Slf4j;
import org.apache.poi.hssf.usermodel.HSSFDataFormat;
import org.apache.poi.hssf.util.HSSFColor;
import org.apache.poi.ss.usermodel.CellStyle;
import org.apache.poi.xssf.streaming.SXSSFCell;
import org.apache.poi.xssf.streaming.SXSSFRow;
import org.apache.poi.xssf.streaming.SXSSFSheet;
import org.apache.poi.xssf.streaming.SXSSFWorkbook;
import org.apache.poi.xssf.usermodel.XSSFRichTextString;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.util.ArrayList;
import java.util.Iterator;
import java.util.LinkedHashMap;
import java.util.List;
@Slf4j
public class ExportExcelStandard {
private String sheetName; // 导出表格的表名
private String[] rowName;// 导出表格的列名
private List<LinkedHashMap<String, Object>> dataList = new ArrayList<>(); // 对象数组的List集合
private HttpServletResponse response;
private HttpServletRequest request;
private String fileName;
private String filePath;
public ExportExcelStandard(String sheetName, String[] rowName, List<LinkedHashMap<String, Object>> dataList, HttpServletRequest request, HttpServletResponse response) {
this.rowName = rowName;
this.dataList =