这是一个函数，我用它来获取工作表中合并单元格的详细信息。
一旦你有了它，你可以在循环中添加一个检查，看看这个单元格是否是合并区域的一部分。

async function Get_Merged_Areas_Arr_Of_Objs(context, rng) {
    //var mergedAreas = ws.getUsedRange(true).getMergedAreasOrNullObject();
    var mergedAreas = rng.getMergedAreasOrNullObject();
    mergedAreas.load(["areas"]);
    await context.sync()

    var Merged_Areas_Arr_Of_Objs = []
    if (mergedAreas.isNull != true) {
        var arrlen = mergedAreas.areas.items.length
        for (var ai = 0; ai < arrlen; ai += 1) {
            var obj = mergedAreas.areas.items[ai]
            var rng_obj = {}
            rng_obj['worksheet'] = obj['address'].split("!")[0]
            rng_obj['rowIndex'] = obj['rowIndex']
            rng_obj['columnIndex'] = obj['columnIndex']
            rng_obj['rowCount'] = obj['rowCount']
            rng_obj['columnCount'] = obj['columnCount']
            rng_obj['end_rowIndex'] = obj['rowIndex'] + obj['rowCount'] - 1
            rng_obj['value'] = obj['values'][0].toString()
            Merged_Areas_Arr_Of_Objs.push(rng_obj)
        }
    }
    return Merged_Areas_Arr_Of_Objs
}