刚学 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')