原 easyexcel（十八）：导出excel多sheet

版权声明：本文为博主原创文章，请尊重他人的劳动成果，转载请附上原文出处链接和本声明。
本文链接：https://www.91mszl.com/zhangwuji/article/details/1461

一：引入pom

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

二：导出excel多sheet

/**
 * 功能：easyexcel导出excel多sheet
 * 来源：https://91mszl.com
 * @Author: zxb
 * @Date: 2023-12-09 11:38:26
 */
@GetMapping("/download")
public void download(HttpServletResponse response) throws IOException {
	String fileName = System.currentTimeMillis() + ".xlsx";
	response.reset();
	response.addHeader("Content-Disposition", "attachment; filename=\"" + fileName + "\"");
	OutputStream os=response.getOutputStream();

	List<UserInfo> dataList=new ArrayList<>();
	UserInfo u1=new UserInfo();
	u1.setName("张无忌");
	u1.setAge(18);
	u1.setAddress("上海市青浦区虹桥国际机场1号");

	UserInfo u2=new UserInfo();
	u2.setName("赵敏");
	u2.setAge(20);
	u2.setAddress("上海市黄浦区东方明珠大厦100号");

	dataList.add(u1);
	dataList.add(u2);

	List<List<String>> headList=new ArrayList<>();
	headList.add(Lists.newArrayList("姓名"));
	headList.add(Lists.newArrayList("年龄"));
	headList.add(Lists.newArrayList("地址"));

	ExcelWriter excelWriter = null;
	try {
		excelWriter = EasyExcel.write(os).build();
		WriteSheet sheet1 = EasyExcel.writerSheet(1, "用户信息1").head(headList).build();
		excelWriter.write(dataList, sheet1);

		WriteSheet sheet2 = EasyExcel.writerSheet(2, "用户信息2").head(headList).build();
		excelWriter.write(dataList, sheet2);
	} finally {
		if (excelWriter != null) { // 关闭流
			excelWriter.finish();
		}
	}
}

三：最终效果图