l = []

with open(file,'rt') as f:

cr = csv.reader(f)

for row in cr:

l.append(row)

f.close()

peopleList = []

wb = xlrd3.open_workbook(filename=file)

sheet1 = wb.sheet_by_index(0)

for i in range(1,sheet1.nrows):

peopleList.append(sheet1.row(i)[2].value)

wb.release_resources()

peopleList = peoples(input("请输入成员列表文件名（带后缀名，xlsx格式）\n"))

#需要删除的成员名

peopleList.remove("")

todayList = today(input("请输入考勤列表文件名（带后缀名，csv格式）\n"))

rpeople = peopleList.copy()

repeat = []

i=0

print("\n")

for rows in todayList:

if rows:

for people in peopleList:

if(people in rows[0] and len(rows)>1):

if(int(rows[2])<170):

print("时长异常：",people,rows[2],rows[3])

if(people in rpeople):

rpeople.remove(people)

else:

i-=1

repeat.append(people)

i+=1

if repeat:

print("\n多次出现：",repeat,"\n")

if rpeople:

print("今日未在线：",rpeople)