表格合并的问题， 最后一个data= []， 出现了N个值， 该怎么解决

Question

刚学 python 没多久，想做一个表格一键合并的程序，发现是倒数第二行的 #data 有问题，导致数据不能全部得导入新文件，望指正一下错误

代码如下
——————————————

import xlrd
import xlwt
import os

title = [' 考勤号码 ', ' 姓名 ', ' 部门 ', ' 日期 ', ' 时间 ']
workbook = xlwt.Workbook('utf-8')
sheet=workbook.add_sheet('file_1',cell_overwrite_ok=True)
path = 'C:/Users/Administrator/Desktop/ 打卡记录 /'
path = 'C:/Users/Administrator/Desktop/path/'
file_list = os.listdir(path)

print(file_list)
for file in file_list:
    file_name = os.path.join(path,file)
    workbook = xlrd.open_workbook(file_name)
    sheet_name = workbook.sheet_names()  
    j = 0
    for i in title:
    sheet.write(0,j,i)
    j += 1
    for file1 in sheetname:
        data = []
        table = workbook.sheetbyindex(0)
        rows = table.nrows
        cols = table.ncols
        for k in (range(rows)[1:]):
            data.append(table.rowvalues(k))
            for h in range(len(data)):
            for k in range(len(data[h])):
                sheet.write(h+1,k,data[h][k])

    #print(data)  打印出三个列表
f.save('result.xlsx')

Answer 1

https://blog.csdn.net/Joey_yk/article/details/82350359