这可以通过Xlsxwriter来实现。
这是一个例子，我已经包括了一些额外的数据在列表中显示;

import xlsxwriter

data_list = [
    {"12345":
         {"cup": "123456789",
          "spoon": "234567891",
          }
     },
    {"23456":
         {"plate": "345678912",
          }
     },
    {"11111":
         {"knife": "12121212",
          "fork": "23232323",
          "spoon": "34343434"
          }
     },
    {"22222":
         {"cup": "56565656",
          "saucer": "67676767"
          }
     }
]

### New workbook and sheet
wb = xlsxwriter.Workbook('xlsxwriter_merge_example.xlsx')
ws = wb.add_worksheet()

### Cell formatting
header_format = wb.add_format({"bold": True, "num_format": "0", "align": "center", "valign": "vcenter", "border": 1})
cell_format_str = wb.add_format({"border": 1})
cell_format_num = wb.add_format({"num_format": "0", "border": 1})

ws.write(0, 0, 'Order', header_format)
ws.merge_range("B1:C1", "Item", header_format)

row_index = 1
for row_data in data_list:
    for col_index, (cell_key, cell_value) in enumerate(row_data.items()):
        if len(cell_value) >= 2:
            ws.merge_range(row_index,
                           col_index,
                           (row_index + len(cell_value)) - 1,
                           col_index,
                           int(cell_key),
                           header_format)
        else:
            ws.write(row_index, col_index, int(cell_key), header_format)
        for item_key, item_value in cell_value.items():
            ws.write(row_index, col_index + 1, item_key, cell_format_str)
            ws.write(row_index, col_index + 2, int(item_value), cell_format_num)
            row_index += 1

ws.autofit()
wb.close()

字符串
带有额外数据的输出表。
已应用最少量的格式设置。
x1c 0d1x的数据