- 技术博客
- Python在文件夹获取所有表格的数据
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)
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
()
这样把所有表格的数据写在文本
