pom依賴：

<dependency><groupId>org.apache.poi</groupId><artifactId>poi-ooxml</artifactId><version>5.2.5</version>
</dependency><dependency><groupId>com.alibaba</groupId><artifactId>easyexcel</artifactId><version>3.3.2</version>
</dependency>

替換核心代碼：

public static InputStream onlineWriter(String fileType, InputStream inputStream, JSONObject model) throws Exception {ByteArrayOutputStream out = new ByteArrayOutputStream();try (ExcelWriter excelWriter = EasyExcel.write(out).withTemplate(inputStream).registerWriteHandler(new CustomCellWeightWeightConfig()).registerWriteHandler(new CustomMergeStrategy()).build()) {// 設置自動換行，前提內容中需要加「\n」才有效WriteCellStyle writeCellStyle = new WriteCellStyle();writeCellStyle.setWrapped(true);HorizontalCellStyleStrategy cellStyleStrategy = new HorizontalCellStyleStrategy(null, writeCellStyle);WriteSheet writeSheet = EasyExcel.writerSheet().registerWriteHandler(cellStyleStrategy).build();excelWriter.fill(model, writeSheet);FillConfig fillConfig = FillConfig.builder().forceNewRow(Boolean.TRUE).build();for (Map.Entry<String, Object> entry : model.entrySet()) {if (entry.getValue() instanceof ArrayList) {JSONArray jsonArray = JSON.parseArray(JSONObject.toJSONString(entry.getValue()));FillWrapper fillWrapper = new FillWrapper(entry.getKey(), jsonArray);excelWriter.fill(fillWrapper, fillConfig, writeSheet);}}excelWriter.finish();}return new ByteArrayInputStream(out.toByteArray());
}

自定義調整行高策略：

/*** 填充內容包含\n換行符，重新計算行高*/
public class CustomCellWeightWeightConfig extends AbstractColumnWidthStyleStrategy {private Map<Integer, Map<Integer, Integer>> CACHE = new HashMap<>();@Overrideprotected void setColumnWidth(WriteSheetHolder writeSheetHolder, List<WriteCellData<?>> cellDataList, Cell cell, Head head, Integer relativeRowIndex, Boolean isHead) {boolean needSetWidth = isHead || StringUtils.isNotEmpty(cellDataList);if (needSetWidth) {//包含\n的內容修改行高String cellValue = getCellValue(cell);boolean contains =  StringUtils.contains(cellValue, ExcelTemplateUtil.WRAPPED);if (contains) {int rows = cellValue.split(ExcelTemplateUtil.WRAPPED).length;float height = cell.getRow().getHeightInPoints();cell.getRow().setHeightInPoints(rows * height);}}}public static String getCellValue(Cell cell) {String cellValue;switch (cell.getCellType()) {case STRING:cellValue = cell.getStringCellValue();break;case BOOLEAN:cellValue = String.valueOf(cell.getBooleanCellValue());break;case NUMERIC:cellValue = String.valueOf(cell.getNumericCellValue());break;default:cellValue = "";break;}return cellValue;}}

自定義合并表格策略：

/*** 表格填充 每一列都賦值上一列的格式，確保列格式一致*/
public class CustomMergeStrategy extends AbstractMergeStrategy {@Overrideprotected void merge(Sheet sheet, Cell cell, Head head, Integer relativeRowIndex) {if(relativeRowIndex==null ||relativeRowIndex==0){return;}int rowIndex = cell.getRowIndex();int colIndex = cell.getColumnIndex();sheet=cell.getSheet();Row preRow = sheet.getRow(rowIndex - 1);Cell preCell = preRow.getCell(colIndex);//獲取上一行的該格List<CellRangeAddress> list = sheet.getMergedRegions();for (int i = 0; i < list.size(); i++) {CellRangeAddress cellRangeAddress = list.get(i);if (cellRangeAddress.containsRow(preCell.getRowIndex()) && cellRangeAddress.containsColumn(preCell.getColumnIndex())) {int lastColIndex = cellRangeAddress.getLastColumn();int firstColIndex = cellRangeAddress.getFirstColumn();if (lastColIndex > firstColIndex) {int lastRowIndex = cellRangeAddress.getLastRow();CellRangeAddress cra = new CellRangeAddress(rowIndex, rowIndex, firstColIndex, lastColIndex);sheet.addMergedRegion(cra);//設置合并區域cra的邊框RegionUtil.setBorderBottom(BorderStyle.THIN, cra, sheet);RegionUtil.setBorderLeft(BorderStyle.THIN, cra, sheet);RegionUtil.setBorderRight(BorderStyle.THIN, cra, sheet);RegionUtil.setBorderTop(BorderStyle.THIN, cra, sheet);return;}}}}}