使用java检测单元格是否已合并

可以使用Apache POI库来检测单元格是否已合并。下面是一个示例代码：

import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;

import java.io.File;
import java.io.FileInputStream;
import java.io.IOException;

public class CheckMergedCells {
    public static void main(String[] args) throws IOException {
        String filepath = "path/to/excel/file.xlsx";
        int sheetIndex = 0;
        int rowIndex = 0;
        int columnIndex = 0;

        FileInputStream fileInputStream = new FileInputStream(new File(filepath));
        Workbook workbook = new XSSFWorkbook(fileInputStream);
        Sheet sheet = workbook.getSheetAt(sheetIndex);
        Cell cell = sheet.getRow(rowIndex).getCell(columnIndex);

        boolean isMergedCell = isMergedRegion(sheet, rowIndex, columnIndex);
        if (isMergedCell) {
            System.out.println("Cell is merged.");
        } else {
            System.out.println("Cell is not merged.");
        }

        fileInputStream.close();
        workbook.close();
    }

    private static boolean isMergedRegion(Sheet sheet, int row, int column) {
        int mergedRegionsCount = sheet.getNumMergedRegions();
        for (int i = 0; i < mergedRegionsCount; i++) {
            Cell mergedCell = sheet.getMergedRegion(i).getCell(0, 0);
            int mergedCellRow = sheet.getMergedRegion(i).getFirstRow();
            int mergedCellColumn = sheet.getMergedRegion(i).getFirstColumn();

            if (mergedCellRow == row && mergedCellColumn == column) {
                return true;
            }
        }
        return false;
    }
}

在上面的示例代码中，我们首先打开 Excel 文件，并从指定的工作表、行和列中获取单元格对象。接下来，我们使用自定义的 `isMergedRegion()` 方法来检查单元格是否已合并。该方法首先获取工作表中合并区域的数量，然后遍历每个合并区域，以查找与当前行和列匹配的合并单元格。如果找到匹配的合并单元格，则返回 `true`，否则返回 `false`。