可以看到代码中指定合并的部分现在已经显示出了效果。
模板
List supplyAreaList = saBiz.getSupplyAreaById(supplyAreaId); SupplyArea sa = (SupplyArea) supplyAreaList.get(0); Long id = sa.getSupplyAreaId(); List qcList = new ArrayList(); QueryCondition idObj = new QueryCondition(); idObj.setFieldName("supplyAreaId"); idObj.setQueryOperator(QueryOperator.le); idObj.setValue(id); qcList.add(idObj); List recordsList = saBiz.getRecords(qcList, new SupplyArea()); int i = recordsList.size(); String templateDir = "D:/excel/template/SupplyAreaDynaMergeCells.xls"; String targetDir="D:/excel/export/testDynaMergeCells.xls"; InputStream is = new FileInputStream(templateDir); Map beans = new HashMap(); beans.put("suplyArea", recordsList); //关联模板 XLSTransformer transformer = new XLSTransformer(); HSSFWorkbook workBook = transformer.transformXLS(is, beans); HSSFSheet sheet = workBook.getSheetAt(0); sheet.addMergedRegion(new Region(2,(short)0,2+i,(short)0)); sheet.addMergedRegion(new Region(2,(short)2,2+i,(short)2)); OutputStream os = new FileOutputStream(targetDir); workBook.write(os); is.close(); os.flush(); os.close();
导出结果