合并一个文文件夹下的所有Excel文件

# Author：Winter Liu
import xlrd
import xlsxwriter
import os

# 获取文件目录
file_list = os.listdir("C:PycharmProjectspython level upexcel_file")
end_xls = "xkb_end.xlsx"

data = []
for xls_name in file_list:
    # 打开xls文件
    f = xlrd.open_workbook("C:PycharmProjectspython level upexcel_file\" + xls_name)
    # 创建表对象列表
    sheets = f.sheets()
    # 表对象
    sheet = sheets[0]
    # 表函数
    n = sheet.nrows
    m = 0 if len(data) == 0 else 1
    for i in range(m, n):
        # 获取每行
        rdata = sheet.row_values(i)
        data.append(rdata)

# 备写文件打开
wr = xlsxwriter.Workbook(end_xls)
# 添加表
ws = wr.add_worksheet()
i = 0
for row in data:
    for col_num, da in enumerate(row):
        # 写入数据，逐个单元格
        ws.write(i, col_num, da)
    i = i+1
wr.close()