java获取合并单元格的值

在Java中，如果要获取合并单元格的值，你可以使用Apache POI库来操作Excel文件。下面是一个示例代码，演示如何获取合并单元格的值：

import org.apache.poi.ss.usermodel.*;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;

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

public class MergeCellValues {
    public static void main(String[] args) {
        try (FileInputStream file = new FileInputStream("path/to/your/excel/file.xlsx")) {
            Workbook workbook = new XSSFWorkbook(file);
            Sheet sheet = workbook.getSheetAt(0);
            for (Row row : sheet) {
                for (Cell cell : row) {
                    if (cell.getCellType() == CellType.STRING) {
                        if (cellIsMerged(sheet, cell)) {
                            String mergedValue = getMergedCellValue(sheet, cell);
                            System.out.println(mergedValue);
                        } else {
                            System.out.println(cell.getStringCellValue());
                        }
                    }
                }
            }
            workbook.close();
        } catch (IOException e) {
            e.printStackTrace();
        }
    }

    private static boolean cellIsMerged(Sheet sheet, Cell cell) {
        int numMergedRegions = sheet.getNumMergedRegions();
        for (int i = 0; i < numMergedRegions; i++) {
            CellRangeAddress range = sheet.getMergedRegion(i);
            if (range.isInRange(cell.getRowIndex(), cell.getColumnIndex())) {
                return true;
            }
        }
        return false;
    }

    private static String getMergedCellValue(Sheet sheet, Cell cell) {
        int numMergedRegions = sheet.getNumMergedRegions();
        for (int i = 0; i < numMergedRegions; i++) {
            CellRangeAddress range = sheet.getMergedRegion(i);
            if (range.isInRange(cell.getRowIndex(), cell.getColumnIndex())) {
                Row firstRow = sheet.getRow(range.getFirstRow());
                Cell firstCell = firstRow.getCell(range.getFirstColumn());
                return firstCell.getStringCellValue();
            }
        }
        return null;
    }
}

请确保将代码中的 `"path/to/your/excel/file.xlsx"` 替换为你实际的Excel文件路径。这段代码遍历了Excel文件中的每个单元格，如果某个单元格是合并单元格，则获取合并单元格的值。否则，直接获取普通单元格的值。

希望这可以帮助到你！