// POI 手動合并的邏輯示例
CellRangeAddress region = new CellRangeAddress(0, 0, 0, 3);
sheet.addMergedRegion(region);

@Data
public class EmployeeReportDTO {
    
    @ExcelProperty(value = "部門", mergeColumn = true)   // 相同部門自動合并
    private String department;
    
    @ExcelProperty("姓名")
    private String name;
    
    @ExcelProperty("工號")
    private String employeeId;
    
    @ExcelProperty("入職日期")
    private String hireDate;
}

EasyExcel.write(response.getOutputStream(), EmployeeReportDTO.class)
    .sheet("員工報表")
    .doWrite(dataList);

import com.alibaba.excel.write.handler.CellWriteHandler;
import com.alibaba.excel.write.metadata.holder.WriteSheetHolder;
import com.alibaba.excel.write.metadata.holder.WriteTableHolder;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.util.CellRangeAddress;

import java.util.HashMap;
import java.util.Map;

public class CustomMergeStrategy implements CellWriteHandler {

    private int[] mergeColumnIndex;          // 需要合并的列索引數組
    private int mergeRowIndex;                // 起始合并的行號
    private Map<String, Integer> mergeCache;  // 合并緩存

    // 構造函數：指定需要合并的列和起始行
    public CustomMergeStrategy(int[] mergeColumnIndex, int mergeRowIndex) {
        this.mergeColumnIndex = mergeColumnIndex;
        this.mergeRowIndex = mergeRowIndex;
        this.mergeCache = new HashMap<>();
    }

    @Override
    public void afterCellDispose(WriteSheetHolder writeSheetHolder, 
                                  WriteTableHolder writeTableHolder,
                                  List<Cell> cellList, Cell cell, 
                                  int relativeRowIndex, boolean isHead) {
        // 表頭不合并
        if (isHead) return;
        
        int curRowIndex = cell.getRowIndex();
        int curColIndex = cell.getColumnIndex();
        
        // 只處理需要合并的列
        boolean needMerge = false;
        for (int index : mergeColumnIndex) {
            if (curColIndex == index) {
                needMerge = true;
                break;
            }
        }
        if (!needMerge) return;
        
        // 獲取當前單元格的值
        String curValue = getCellValue(cell);
        if (curValue == null || curValue.isEmpty()) return;
        
        // 生成唯一鍵：列索引 + 行號
        String cacheKey = curColIndex + "_" + curValue;
        Integer startRow = mergeCache.get(cacheKey);
        
        if (startRow == null) {
            // 第一次出現該值，記錄起始行
            mergeCache.put(cacheKey, curRowIndex);
        } else {
            // 第二次及以后出現，說明這是一個需要合并的區(qū)域
            // 如果當前行已經是最后一行，或下一行的值不同，則執(zhí)行合并
            boolean needMergeNow = isLastRow(writeSheetHolder, curRowIndex) 
                                    || !curValue.equals(getNextRowValue(writeSheetHolder, curRowIndex, curColIndex));
            if (needMergeNow && startRow != curRowIndex) {
                Sheet sheet = writeSheetHolder.getSheet();
                CellRangeAddress range = new CellRangeAddress(startRow, curRowIndex, curColIndex, curColIndex);
                sheet.addMergedRegion(range);
                // 合并后移除緩存，避免重復合并
                mergeCache.remove(cacheKey);
            }
        }
    }
    
    private String getCellValue(Cell cell) {
        if (cell == null) return "";
        switch (cell.getCellType()) {
            case STRING: return cell.getStringCellValue();
            case NUMERIC: return String.valueOf(cell.getNumericCellValue());
            default: return "";
        }
    }
    
    private boolean isLastRow(WriteSheetHolder writeSheetHolder, int curRowIndex) {
        return curRowIndex == writeSheetHolder.getSheet().getLastRowNum();
    }
    
    private String getNextRowValue(WriteSheetHolder writeSheetHolder, int curRowIndex, int curColIndex) {
        Sheet sheet = writeSheetHolder.getSheet();
        if (curRowIndex + 1 > sheet.getLastRowNum()) return null;
        Cell nextCell = sheet.getRow(curRowIndex + 1).getCell(curColIndex);
        return nextCell == null ? null : getCellValue(nextCell);
    }
}

private void exportWithMerge(HttpServletResponse response, List<YourDTO> dataList) {
    try {
        EasyExcel.write(response.getOutputStream(), YourDTO.class)
            .registerWriteHandler(new CustomMergeStrategy(
                new int[]{0, 1},   // 合并第1列（部門）和第2列（職位）
                1                  // 從第1行開始合并（跳過表頭）
            ))
            .sheet("報表")
            .doWrite(dataList);
    } catch (IOException e) {
        throw new RuntimeException("導出失敗", e);
    }
}

<template>
  <div class="excel-container">
    <button @click="exportToBackend">保存并導出</button>
    <div id="luckysheet" style="width:100%; height:600px;"></div>
  </div>
</template>
<script setup>
import { onMounted, ref } from 'vue';
import axios from 'axios';
const sheetData = ref(null);
onMounted(() => {
  // 初始化 Luckysheet
  luckysheet.create({
    container: 'luckysheet',
    lang: 'zh',
    data: [{
      name: 'Sheet1',
      status: '1',
      row: 100,
      column: 20,
      celldata: []  // 可從后端加載已有數據
    }]
  });
  // 監(jiān)聽數據變化
  luckysheet.on('dataChange', () => {
    sheetData.value = luckysheet.getSheetData();
  });
});
const exportToBackend = async () => {
  const currentData = luckysheet.getAllSheets();
  // 將 Luckysheet 的數據格式轉換為后端可識別的 JSON
  const exportData = {
    sheets: currentData,
    fileName: '在線編輯報表.xlsx'
  };
  const response = await axios.post('/api/export/edit-excel', exportData, {
    responseType: 'blob'  // 重要：接收文件流
  });
  // 下載文件
  const url = window.URL.createObjectURL(new Blob([response.data]));
  const link = document.createElement('a');
  link.href = url;
  link.setAttribute('download', exportData.fileName);
  document.body.appendChild(link);
  link.click();
  document.body.removeChild(link);
  window.URL.revokeObjectURL(url);
};
</script>

@RestController
@RequestMapping("/api/export")
public class ExcelExportController {

    @PostMapping("/edit-excel")
    public void exportEditedExcel(@RequestBody ExcelEditRequest request, 
                                   HttpServletResponse response) throws IOException {
        // 1. 獲取前端傳來的編輯后數據
        List<Map<String, Object>> editedData = request.getData();
        
        // 2. 使用 EasyExcel 寫入
        response.setContentType("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");
        response.setCharacterEncoding("utf-8");
        String fileName = URLEncoder.encode(request.getFileName(), "UTF-8").replaceAll("\\+", "%20");
        response.setHeader("Content-disposition", "attachment;filename*=utf-8''" + fileName);
        
        // 3. 將前端 JSON 數據轉換為實體類并寫入 Excel
        List<YourEntity> dataList = convertToEntity(editedData);
        EasyExcel.write(response.getOutputStream(), YourEntity.class)
            .sheet("報表")
            .doWrite(dataList);
    }
}