ClassPathResource classPathResource = new ClassPathResource(File.separator + “templates” + File.separator + “execl” + File.separator + “” + “accountsReportWelfare.xlsx”);
TemplateExportParams params = new TemplateExportParams(classPathResource.getPath());
// 获取workbook
Workbook workbook = ExcelExportUtil.exportExcel(params, map);
List list = (List) map.get(“list”);
Map<Integer, int[]> mergeMap = Maps.newHashMap();
//设置合并的条件 根据value列值合并key列
mergeMap.put(26,new int[]{0});
mergeMap.put(27,new int[]{0});
PoiMergeCellUtil.mergeCells(workbook.getSheetAt(0), mergeMap,10);