LinkedHashMap<String, Integer> allColumn = new LinkedHashMap<>();
// 先添加固定列
for (int i = 0; i < strCloumnAry.length; i++) {
    allColumn.putIfAbsent(strCloumnAry[i], i);
}
// 再添加動(dòng)態(tài)列（避免重復(fù)）
int i = strCloumnAry.length;
for (String key : cellList) {
    if (!allColumn.containsKey(key)) {
        allColumn.put(key, i++);
    }
}

if (headerNum == 2) { // 二級(jí)表頭處理
    for (String key : allColumn.keySet()) {
        String[] parts = key.split("\|\|"); // 按||拆分
        if (parts.length == 2) {
            // 一級(jí)表頭行
            Cell cell1 = headerRow1.createCell(allColumn.get(key));
            cell1.setCellValue(parts[0]);
            // 二級(jí)表頭行
            Cell cell2 = headerRow2.createCell(allColumn.get(key));
            cell2.setCellValue(parts[1]);
        }
    }
}

// 寫(xiě)入數(shù)據(jù)行
int row = headerNum; // 表頭行下方開(kāi)始寫(xiě)數(shù)據(jù)
for (Map<String, Object> data : datas) {
    Row dataRow = sheet.createRow(row++);
    for (Map.Entry<String, Integer> entry : allColumn.entrySet()) {
        Cell cell = dataRow.createCell(entry.getValue());
        cell.setCellValue(data.get(entry.getKey()) != null ? data.get(entry.getKey()).toString() : "");
    }
}

// 寫(xiě)入合計(jì)行
Row totalRow = sheet.createRow(row);
totalRow.createCell(0).setCellValue("合計(jì)");
for (Map.Entry<String, Object> entry : totalMap.entrySet()) {
    int colIndex = allColumn.get(entry.getKey());
    Cell cell = totalRow.createCell(colIndex);
    cell.setCellValue(entry.getValue() != null ? entry.getValue().toString() : "");
}
// 合并合計(jì)行標(biāo)題單元格
sheet.addMergedRegion(new CellRangeAddress(row, row, 0, maxSp));

// 創(chuàng)建通用樣式
CellStyle cellStyle = workbook.createCellStyle();
cellStyle.setAlignment(HorizontalAlignment.CENTER);
cellStyle.setVerticalAlignment(VerticalAlignment.CENTER);
cellStyle.setBorderTop(BorderStyle.THIN);
cellStyle.setBorderBottom(BorderStyle.THIN);
cellStyle.setBorderLeft(BorderStyle.THIN);
cellStyle.setBorderRight(BorderStyle.THIN);

// 表頭字體設(shè)置
Font headerFont = workbook.createFont();
headerFont.setFontHeightInPoints((short) 10);
cellStyle.setFont(headerFont);

// 假設(shè)前端傳入動(dòng)態(tài)列名為["price","quantity"]
List<String> cellList = Arrays.asList("price", "quantity");
// 固定列字段名與顯示名
String[] strCloumnAry = {"name", "date"};
String[] strAry = {"商品名稱", "日期"};

// 構(gòu)造模擬數(shù)據(jù)
List<Map<String, Object>> datas = new ArrayList<>();
Map<String, Object> data1 = new HashMap<>();
data1.put("name", "蘋(píng)果");
data1.put("date", "2023-10-01");
data1.put("price", 5.99);
data1.put("quantity", 100);
datas.add(data1);

// 調(diào)用導(dǎo)出方法（二級(jí)表頭示例）
exportDynamicExcel(response, datas, cellList, "商品銷(xiāo)售報(bào)表", strAry, strCloumnAry, 2);