springboot easyexcel实现数据导出成excel表格功能

package xf.excel; import com.alibaba.excel.EasyExcel; import com.alibaba.excel.ExcelWriter; import com.alibaba.excel.write.metadata.WriteSheet; import org.springframework.stereotype.Component; import javax.servlet.http.HttpServletResponse; import java.io.IOException; import java.io.InputStream; import java.util.List; /** * @Author: wangxf * @Date: 2023/10/26 11:08 */ @Component public class ExcelLevelOne { public void writeDataToExcel(HttpServletResponse response) { try { InputStream inputStream = getClass().getResourceAsStream("/excel/用户信息.xlsx"); response.setContentType("application/octet-stream"); response.setCharacterEncoding("utf-8"); // 这里URLEncoder.encode可以防止中文乱码 response.setHeader("Content-Disposition", "attachment;filename=" + java.net.URLEncoder.encode("用户信息.xlsx", "UTF-8")); List<Stu> data = DB.getData(); ExcelWriter excelWriter = EasyExcel.write(response.getOutputStream()) .withTemplate(inputStream) .build(); WriteSheet writeSheet = EasyExcel.writerSheet() .build(); excelWriter.fill(data, writeSheet); excelWriter.finish(); } catch (IOException e) { e.printStackTrace(); } } }