已升级到4.0版本,点击查看
功能:
1、对学生信息进行随机排序,并生成考号、考试、座位号
2、根据排序信息生成座位签
import pandas as pd
from openpyxl import Workbook
from openpyxl.styles import Alignment,Font,Border,Side
from random import *
from time import sleep
columns = ['班级', '姓名', '语文', '数学', '外语', '物理', '考号', '考室', '座位号']
cells = ['A','B','C','D','E','F']
width = {
1:20,2:25,3:30}
height = {
1:100,2:120,3:160}
fontsize = {
1:12,2:14,3:18}
border = Border(left=Side(border_style='double',color='000000'),
right=Side(border_style='double',color='000000'),
top=Side(border_style='double',color='000000'),
bottom=Side(border_style='double',color='000000'))
def main():
while True:
chioce = int<