获取每个JSON对象中的合并单元格值

import json

def get_merged_cell_values(json_data):
    data = json.loads(json_data)  # 解析JSON数据
    merged_cell_values = []  # 存储合并单元格值的列表

    for row in data['rows']:
        for cell in row['cells']:
            if 'merged' in cell:  # 判断是否为合并单元格
                start_row = cell['merged']['start']['row']
                start_col = cell['merged']['start']['col']
                end_row = cell['merged']['end']['row']
                end_col = cell['merged']['end']['col']

                for i in range(start_row, end_row + 1):
                    for j in range(start_col, end_col + 1):
                        merged_cell_values.append(data['rows'][i]['cells'][j]['value'])

    return merged_cell_values

# 示例JSON数据
json_data = '''
{
  "rows": [
    {
      "cells": [
        {"value": "A1"},
        {"value": "B1"},
        {"value": "C1"},
        {"value": "D1"},
        {"value": "E1"},
        {"value": "F1"},
        {"value": "G1"},
        {"value": "H1"},
        {"value": "I1"},
        {"value": "J1"}
      ]
    },
    {
      "cells": [
        {"value": "A2"},
        {"value": "B2"},
        {"value": "C2"},
        {"value": "D2"},
        {"value": "E2"},
        {"value": "F2"},
        {"value": "G2"},
        {"value": "H2"},
        {"value": "I2"},
        {"value": "J2"},
        {"merged": {"start": {"row": 1, "col": 2}, "end": {"row": 1, "col": 4}}}
      ]
    },
    {
      "cells": [
        {"value": "A3"},
        {"value": "B3"},
        {"value": "C3"},
        {"value": "D3"},
        {"value": "E3"},
        {"value": "F3"},
        {"value": "G3"},
        {"value": "H3"},
        {"value": "I3"},
        {"value": "J3"}
      ]
    }
  ]
}
'''

merged_cell_values = get_merged_cell_values(json_data)
print(merged_cell_values)