准备写一个脚本将文件夹下的所有表格文件内容都读取到一个列表中,但是遇到了标题的错误,经查证是wps中打开了其中一个表格,将其关闭即可顺利运行。
import os
import openpyxl
inputdir='./VOCdevkit2007/results/VOC2007/Main'
sheet_name = 'name'
def read_excel_xlsx(path, sheet_name):
workbook = openpyxl.load_workbook(path)
sheet = workbook[sheet_name]
#print(sheet,sheet_name)
spitlines=[]
for row in sheet.rows:
if row=='':
break
T=[]
for cell in row:
T.append(str(cell.value))
#T1=T[0:7]
#print(T)
spitlines.append(T)
#print(spitlines)
return spitlines
def read_xlsx(inputdir):
splitlines_start = []
for name in os.listdir(inputdir):
name_path=inputdir+'/'+name
spit=read_excel_xlsx(name_path,sheet_name)
#print(spit)
#splitlines.append(spit)
splitlines_start=splitlines_start+spit
print(splitlines_start)
return splitlines_start
read_xlsx(inputdir)