@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; }
excel模板存放路径
excel模板内容配置
