importxlrdimportxlsxwritersource_xls=["D:/python/1.xlsx","D:/python/2.xlsx"]target_xls="D:/python/3.xlsx"#读取数据data=[]foriinsource_xls:wb=xlrd.open_workbook(i)forsheetinwb.sheets():forrownuminrange(sheet.nrows):data.append(sheet.row_values(rownum))print(data)#写入数据inrange(len(data[i])):worksheet.write(i,j,data[i][j],font)#关闭文件流workbook.close()python合并工作表
