使用封闭的xml将网格视图导出到excel，中间相隔1列

import xml.etree.ElementTree as ET
import openpyxl

# 创建一个网格视图对象
grid_view_data = [
    ['姓名', '年龄', '性别'],
    ['张三', '25', '男'],
    ['李四', '30', '女'],
    ['王五', '28', '男']
]

# 将网格视图数据转换为XML格式
root = ET.Element('GridData')
for row in grid_view_data:
    row_element = ET.SubElement(root, 'Row')
    for cell in row:
        cell_element = ET.SubElement(row_element, 'Cell')
        cell_element.text = cell

xml_data = ET.tostring(root)

# 创建Excel文件并打开工作表
workbook = openpyxl.Workbook()
sheet = workbook.active

# 解析XML数据并写入Excel工作表
xml_root = ET.fromstring(xml_data)
row_index = 1
for row_element in xml_root.findall('Row'):
    col_index = 1
    for cell_element in row_element.findall('Cell'):
        cell_value = cell_element.text
        sheet.cell(row=row_index, column=col_index).value = cell_value
        col_index += 2  # 相隔1列
    row_index += 1

# 保存Excel文件
workbook.save('grid_view_data.xlsx')