当前位置：首页 > news >正文

EasyExcel按模板导出excel

news 2026/5/31 13:43:30

@GetMapping("/download1")public void downloadFile1(HttpServletResponse response) throws IOException {// 下载excelString fileName = "excel-template/test.xls";response.setContentType("application/octet-stream");response.setCharacterEncoding("utf-8");response.setHeader("Content-disposition", "attachment;filename=" + URLEncoder.encode("template.xls", StandardCharsets.UTF_8));// 加载模板InputStream inputStream = this.getClass().getClassLoader().getResourceAsStream(fileName);// 输出到responsetry (ExcelWriter excelWriter = EasyExcel.write(response.getOutputStream()).withTemplate(inputStream).excelType(ExcelTypeEnum.XLS).build()) {// 得到sheetWriteSheet writeSheet = EasyExcel.writerSheet().build();
　　　　　　　// 自动换行FillConfig fillConfig = FillConfig.builder().forceNewRow(true).build();// 列表竖向填充List<DetailVo> details = new ArrayList<>();details.add(new DetailVo("1", "任务1", "12", "12", "22"));details.add(new DetailVo("2", "任务2", "12", "12", "22"));excelWriter.fill(cachedDataList, fillConfig, writeSheet);excelWriter.finish();}}

导出实体类对象

package cn.bolangit.system.domain.vo;import com.alibaba.excel.annotation.ExcelProperty;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.EqualsAndHashCode;
import lombok.NoArgsConstructor;@Data
@AllArgsConstructor
@NoArgsConstructor
@EqualsAndHashCode
public class DetailVo {@ExcelProperty("序号")private String seq;@ExcelProperty("具体目标任务")private String task;@ExcelProperty("牵头单位")private String qtdw;@ExcelProperty("责任人")private String zrr;@ExcelProperty("责任单位")private String zrdw;
}