1 Maven依赖
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>easyexcel</artifactId>
<version>2.1.6</version>
</dependency>
2 实现代码
/**
* 导出多个sheet页数据
*
* @param response
*/
@GetMapping("/exportMultiSheet")
public void exportMultiSheet(HttpServletResponse response) {
try {
//第一个Sheet页数据
List<List<Object>> dataList = new ArrayList<>();
List<Object> headList = new ArrayList<>(Arrays.asList(new Object[]{"表头1", "表头2", "表头3"}));
dataList.add(headList);
//第二个Sheet页数据
List<List<Object>> dataList2 = new ArrayList<>();
List<Object> headList2 = new ArrayList<>