import os
import xlwt,xlrd
x = os.listdir()
try:#没有这个表格就报错
    x.remove('合并表格.xls')
    print('---------------------')
except Exception as e:
    print('---------------------')
y = []
def get_xls(ghj):#判断文件是否存在的，是的话就重新建一个表格
    wqe = 0
    f = "".join(ghj)[0:4]
    if os.path.exists(ghj):
        wqe += 1
        return f+str(wqe)+".xls"
def read(xls):#将表格内容写入列表
    bm = xls.split('.')[0]
    data = xlrd.open_workbook(xls)
    table = data.sheet_by_index(0)
    q = table.nrows#行
    for h in range(q):
        b = table.row_values(h)
        b.insert(0,bm)
        y.append(b)
bn = []
def gh(bn):#列表去重函数
    news_ids = []
    for id in bn:
        if id not in news_ids:
            news_ids.append(id)
    return news_ids
def wir(font,wr):#列表内容写入表格
    hi = 0
    fontt = 0
    workboob = xlwt.Workbook(encoding="utf-8")
    worksheet = workboob.add_sheet("合并表格")
    for i in range(font):#切分表格列表
        for g in wr:#切分行
            for wriw in range(0,len(g)):#切分列写入
                worksheet.write(fontt, wriw, g[wriw])
            fontt+=1#行数+1
        break
    workboob.save("合并表格.xls")#保存
for li in x:#遍历本文件夹所有xls/xlsx文件
    if "xls" in li:
        read(li)#将文件内容写入进表格
        print('已读取%s' % li)
wir(len(y),y)#行数写入