无限点名,每一轮都不会重复,同时带小组名称
import xlrd
import random
import time
isGo = True
count = 1
while 1:
data = xlrd.open_workbook('C:\\Users\\Administrator\\Desktop\\2.xlsx')
table = data.sheets()[0]
list = table.col_values(1)
group = table.col_values(0)
list = list[1:6]
group = group[1:6]
data=input('真的点名么??,\n 1:Yes or No \n ')
print('这是第%d轮'%count)
if data == '1':
isGo = True
count = count + 1
else:
isGo = False
break
if isGo == True:
while 1:
input('任意键开始随机点名:')
Num = random.randint(0,len(list)-1)
newList = list[0:6]
delName = newList[Num]
list.remove(delName)
newGroup = group[0:6]
delGroup = newGroup[Num]
print(delGroup,delName)
group.remove(delGroup)
if len(list) == 0:
print('所有同学已被点名,不要在点了')
print('名单将在3s后重新加载,颤抖吧,小蜗牛们!!!')
time.sleep(3)
break