合并excel

import os
import xlrd



def read_excel(path):
    wb = xlrd.open_workbook(path)
    sheet_name = wb.sheet_names()[0]
    # print(sheet_name)
    sheet = wb.sheet_by_name(sheet_name)
    # print(sheet.name, sheet.nrows, sheet.ncols)
    x = sheet.nrows
    for i in range(x):
        for z in range(13):
            if z == 12:
                y = sheet.cell_value(i, z) + '\n'
            else:
                y = sheet.cell_value(i, z) + '|'
            with open('./result.txt', 'a+', encoding='utf-8') as fp:
                fp.write(y)

# 获取文件名
path = 'G:/三资系统/三资系统'
file_names = os.listdir(path)
# print(file_names)
# 文件名拼接路径
n = 0
for file in file_names:
    path1 = os.path.join(path, file)
    # print(path1)
    file_names1 = os.listdir(path1)
    for file1 in file_names1:
        # print(file1)
        path2 = os.path.join(path1, file1)
        # print(path2)
        read_excel(path2)
        n += 1
        print(f'第{n}个文件{path2}已完成读取')
print('结束')