提示：本文档的示例代码仅适用于本文档中的示例报表/场景。若实际报表/场景与示例代码无法完全适配（如使用功能不一致，或多个宏代码冲突等），需根据实际需求开发代码。

function main(pageServer: IPageServer, portletServer: ITableSheetPortletServer) {
    /*工作表中的单元格*/
    let cells = portletServer.getWorkbook().getWorksheets().get("Sheet1").getCells();
    let C5PosList = portletServer.getSheets()[0].getExpandedPositions("C5");
    let D5PosList = portletServer.getSheets()[0].getExpandedPositions("D5");
    /*获取原始的D5、E5样式*/
    let D5Style = cells.get("D5").getStyle();
    let E5Style = cells.get("E5").getStyle();
    for (let i = 0; i < C5PosList.length; i++) {
        let C5Sub = cells.get(C5PosList[i].getRow(), C5PosList[i].getColumn());
        let fromRow = C5Sub.getRow();
        let toRow = C5Sub.getRow();
        /*计算行数*/
        let mergedRange = C5Sub.getMergedRange();
        if (mergedRange) {
            toRow += mergedRange.getRowCount() - 1;
        }
        for (let z = fromRow; z <= toRow; z++) {
            for (let j = 0; j < D5PosList.length; j++) {
                /*获取单元格*/
                let cell = cells.get(z, D5PosList[j].getColumn());
                mergedRange = cell.getMergedRange();
                if (mergedRange) {
                    /*如果产生了合并单元格，取消合并*/
                    cells.unMerge(mergedRange.getFirstRow(), mergedRange.getFirstColumn(),
                        mergedRange.getRowCount(), mergedRange.getColumnCount());
                }
                /*设置样式*/
                cell.setStyle(D5Style);
                /*获取单元格*/
                cell = cells.get(z, D5PosList[j].getColumn() + 1);
                mergedRange = cell.getMergedRange();
                if (mergedRange) {
                    /*如果产生了合并单元格，取消合并*/
                    cells.unMerge(mergedRange.getFirstRow(), mergedRange.getFirstColumn(),
                        mergedRange.getRowCount(), mergedRange.getColumnCount());
                }
                /*设置样式*/
                cell.setStyle(E5Style);
            }
        }
    }
}