import os
import xlrd
start_directory = r'huiyi'
data = os.path.join(start_directory)
arrlist = os.listdir(data)
data_list = []
file = open('huiyi.txt', 'w')
for excel in arrlist:
excelPath = os.path.join(data, excel) # 拼接路径
excels = xlrd.open_workbook(excelPath)
sheetnames = excels.sheet_names()
for sheet in sheetnames:
table = excels.sheet_by_name(sheet)
keys = table.row_values(0) # 第一行作为key值
rowNum = table.nrows # 获取表格行数
colNum = table.ncols
for i in range(1, rowNum):
row_value = table.row_values(i)
data_list.append(row_value)
for k, w in data_list:
print(k)
file.write(k + '\n')
file.close()
这样把所有表格的数据写在文本