poi处理excel的合并单元格写的工具类,支持xlsx和xls

1.判断当前单元格是不是合并单元格

...
    private boolean isMergedRegion(Sheet sheet, int row, int column) {
        //获取合并单元格的数量
        int sheetMergeCount = sheet.getNumMergedRegions();
        //循环合并的单元格
        for (int i = 0; i < sheetMergeCount; i++) {
            //获取合并单元格对象
            CellRangeAddress range = sheet.getMergedRegion(i);
            //获取第i个合并单元格的边界
            int firstColumn = range.getFirstColumn();
            int lastColumn = range.getLastColumn();
            int firstRow = range.getFirstRow();
            int lastRow = range.getLastRow();
            //通过判断边界的大小范围来判断是不是合并单元格
            if (row >= firstRow && row <= lastRow) {
                if (column >= firstColumn && column <= lastColumn) {
                    return true;
                }
            }
        }
        return false;
    }
...

2.获取单元格的边界内容

...
    public Map<String, Integer> getMergedRegionRange(Sheet sheet, int row, int column) {
        //获取合并单元格的数量
        int sheetMergeCount = sheet.getNumMergedRegions();
        //循环获取的合并单元格
        for (int i = 0; i < sheetMergeCount; i++) {
            CellRangeAddress ca = sheet.getMergedRegion(i);
            //获取合并单元格的边界
            int firstColumn = ca.getFirstColumn();
            int lastColumn = ca.getLastColumn();
            int firstRow = ca.getFirstRow();
            int lastRow = ca.getLastRow();
            //如果这个是合并单元格，将内容放在map里面
            if (row >= firstRow && row <= lastRow) {
                if (column >= firstColumn && column <= lastColumn) {
                    Row fRow = sheet.getRow(firstRow);
                    Map<String, Integer> cellRangeMap = new HashMap<>();
                    cellRangeMap.put("firstRow", firstRow);
                    cellRangeMap.put("lastRow", lastRow);
                    cellRangeMap.put("firstColumn", firstColumn);
                    cellRangeMap.put("lastColumn", lastColumn);
                    return cellRangeMap;
                }
            }
        }
        return null;
    }
...

3.获取单元格的值

...
    public String getMergedRegionValue(Sheet sheet, int row, int column) {
        //获取合并单元格的数量
        int sheetMergeCount = sheet.getNumMergedRegions();
        //循环获取的合并单元格
        for (int i = 0; i < sheetMergeCount; i++) {
            CellRangeAddress ca = sheet.getMergedRegion(i);
            int firstColumn = ca.getFirstColumn();
            int lastColumn = ca.getLastColumn();
            int firstRow = ca.getFirstRow();
            int lastRow = ca.getLastRow();
            if (row >= firstRow && row <= lastRow) {
                if (column >= firstColumn && column <= lastColumn) {
                    Row fRow = sheet.getRow(firstRow);
                    Cell fCell = fRow.getCell(firstColumn);
                    return getCellValue(fCell);
                }
            }
        }
        return null;
    }
...

4.设置合并单元格

...
int firstRow = Integer.parseInt(((HashMap) topRangeMap).get("firstRow").toString());
int lastRow = Integer.parseInt(((HashMap) topRangeMap).get("lastRow").toString());
int firstColumn = Integer.parseInt(((HashMap) topRangeMap).get("firstColumn").toString());
int lastColumn = Integer.parseInt(((HashMap) topRangeMap).get("lastColumn").toString());
        CellRangeAddress cra = new CellRangeAddress(firstRow, lastRow, firstColumn, lastColumn);
        sheet.addMergedRegion(cra);
...