python合并两个简单的excel表

需要xlrd和xlsxwriter模块

import xlrd
import xlsxwriter

source_xls = ["F:/python实验/1.xlsx", "F:/python实验/2.xlsx"]
target_xls = "F:/python实验/3.xlsx"

data = []
for i in source_xls:
    sx = xlrd.open_workbook(i)#打开文件；增加‘rb’可解决名字含中文错误
    for sheet in sx.sheets():   #sx.sheets()获取对象
        for rownum in range(sheet.nrows):   #sheet.nrows获取有效行数
            data.append(sheet.row_values(rownum))#append函数会在数组后加上相应的元素
                                                #sheet.row_values(rownum)获取有效行数据
print(sx.sheet_names())#打印文件名称
print(data)

workbook = xlsxwriter.Workbook(target_xls)#创建文件
worksheet = workbook.add_worksheet()#新建数据表
font = workbook.add_format({"font_size":14})

for i in range(len(data)):
    for j in range(len(data[i])):
        worksheet.write(i, j, data[i][j], font)

workbook.close()