java导出excel模板demo

package com.example.demoexcel.util; import com.alibaba.excel.EasyExcel; import com.alibaba.excel.ExcelWriter; import com.alibaba.excel.write.metadata.WriteSheet; import com.alibaba.excel.write.metadata.fill.FillConfig; import com.example.demoexcel.domain.ExportData; import com.example.demoexcel.domain.ExportTitle; import org.springframework.core.io.ClassPathResource; import javax.servlet.ServletOutputStream; import javax.servlet.http.HttpServletResponse; import java.io.IOException; import java.io.InputStream; import java.util.List; public class ExportUtil { public static void fillExcel(HttpServletResponse response, ExportTitle exportTitle, List<ExportData> list) throws IOException { ServletOutputStream out = response.getOutputStream(); response.setContentType("multipart/form-data"); response.setCharacterEncoding("UTF-8"); //文件名字 String fileName = "demo.xlsx"; response.setHeader("Content-disposition", "attachment;filename=" +fileName); //文件模板输入流 InputStream inputStream = new ClassPathResource("templates/demo.xlsx").getInputStream(); ExcelWriter writer = EasyExcel.write(out).withTemplate(inputStream).build(); WriteSheet sheet = EasyExcel.writerSheet(0).build(); //填充列表开启自动换行,自动换行表示每次写入一条list数据是都会重新生成一行空行,此选项默认是关闭的,需要提前设置为true FillConfig fillConfig = FillConfig.builder().forceNewRow(true).build(); //填充标题 writer.fill(exportTitle,sheet); //填充数据 writer.fill(list,fillConfig,sheet); //填充完成 writer.finish(); out.flush(); } }