使用python和xlrd合并/合并两个不同的电子表格

import xlrd
import xlwt

def merge_excel(file1, file2, output_file):
    # 打开第一个电子表格文件
    workbook1 = xlrd.open_workbook(file1)
    sheet1 = workbook1.sheet_by_index(0)

    # 打开第二个电子表格文件
    workbook2 = xlrd.open_workbook(file2)
    sheet2 = workbook2.sheet_by_index(0)

    # 创建一个新的电子表格文件
    merged_workbook = xlwt.Workbook()
    merged_sheet = merged_workbook.add_sheet('Merged Sheet')

    # 复制第一个电子表格文件的内容到新文件
    for row in range(sheet1.nrows):
        for col in range(sheet1.ncols):
            merged_sheet.write(row, col, sheet1.cell_value(row, col))

    # 复制第二个电子表格文件的内容到新文件
    for row in range(sheet2.nrows):
        for col in range(sheet2.ncols):
            merged_sheet.write(row + sheet1.nrows, col, sheet2.cell_value(row, col))

    # 保存合并后的电子表格文件
    merged_workbook.save(output_file)

# 调用函数合并两个电子表格文件
merge_excel('file1.xlsx', 'file2.xlsx', 'merged_file.xlsx')