import random
import pandas as pd
import pygame
from tkinter import *
import tkinter.messagebox
from pandas import DataFrame
import numpy
import os
# 读取相关数据,将姓名与学号放到列表中
win =Tk()
def suijishuchu(var1):
os.system("cls")
bjh=str(var1)
files = "学生名单.xlsx"
data1 = pd.read_excel(files,sheet_name=bjh)
data2=data1.iloc[:].values
#data3=data1.iloc[0].values
b=[j[:] for j in data2] #按行读出所有数据,并以列表形式存储
suiji=random.sample(b,1) #随机出某一行内容
xingming = [j[1] for j in suiji] # 读出第二列
xuehao=[j[0] for j in suiji] #读出第一列
text1 = Text(win, width=10, height=3)
text1.tag_config("tag_1", justify="center", font=("微软雅黑", 20)) # 设置输入内容的属性
text1.insert("1.0", xuehao, "tag_1") # text.insert(“行数,列数”,显示内容,显示内容属性)
text1.pack(anchor="n", side="left", padx=310, pady=100)
# 姓名设计
text2 = Text(win, width=20, height=3)
text2.tag_config("tag_2", justify="center", font=("微软雅黑", 20)) # 设置输入内容的属性
text2.insert("1.0", xingming, "tag_2") # text.insert(“行数,列数”,显示内容,显示内容属性)
text2.place(x=470, y=151)
Cmd1=Button(win,text="3班",command=lambda:suijishuchu(var1=3),relief="solid",width=10,height=2)
Cmd1.place(x=200,y=300)
win.mainloop()