原来编排的时候需要手动编排；
经常会搞错时间；
下拉时需要非常小心；
索性做一个模板；
直接生成足够数量的考场；
之后把学生和学号粘贴过来就可以了；

import pandas as pd

'''
计算机应用基础考场模板生成
'''
# 考试日期
ls_dates = ['2019-12-20', '2019-12-21']
# 考试时间
ls_times = ['8:30:00-10:10', '10:30:00-12:10', '13:30:00-15:10', '15:30:00-17:10']


# 考试日期/时间
def get_ls_dates_and_times(ls_dates, ls_times):
    ls_dates_and_times = []
    for date in ls_dates:
        for time in ls_times:
            date_and_time = f'{date} {time}'
            ls_dates_and_times.append(date_and_time)
    return ls_dates_and_times


# 生成考试日期/时间
ls_dates_and_times = get_ls_dates_and_times(ls_dates, ls_times)
# print(ls_dates_and_times)
# 考试机房
ls_class_rooms = ['机房5', '机房9']
# 机房容量
COMPUTER_NUM = 41


# 生成考场数据
def create_data(ls_dates_and_times, ls_class_rooms, COMPUTER_NUM):
    ls_data = []

    for date_and_time in ls_dates_and_times:
        for class_room in ls_class_rooms:
            for i in range(COMPUTER_NUM):
                ls = []
                ls.append(f'{i + 1}')
                ls.append(class_room)
                ls.append(date_and_time)
                ls_data.append(ls)
    return ls_data


ls_data = create_data(ls_dates_and_times, ls_class_rooms, COMPUTER_NUM)
ls_title = ['座位号', '考场号', '考试日期时间']
df = pd.DataFrame(ls_data, columns=ls_title)
print(df)
writer = pd.ExcelWriter('计算机应用基础模板.xlsx')
df.to_excel(writer, '计算机应用基础模板', index=False)
print('ok')
writer.save()
# print(ls_data)

增加”场次号版“

import pandas as pd

'''
计算机应用基础考场模板生成
'''
# 考试日期
ls_dates = ['2020-8-23', '2020-8-24']
# 考试时间
ls_times = ['8:30:00-10:10', '10:30:00-12:10', '13:30:00-15:10', '15:30:00-17:10']


# 考试日期/时间
def get_ls_dates_and_times(ls_dates, ls_times):
    ls_dates_and_times = []
    for date in ls_dates:
        for time in ls_times:
            date_and_time = f'{date} {time}'
            ls_dates_and_times.append(date_and_time)
    return ls_dates_and_times


# 生成考试日期/时间
ls_dates_and_times = get_ls_dates_and_times(ls_dates, ls_times)
# print(ls_dates_and_times)
# 考试机房
ls_class_rooms = ['机房5', '机房9']
# 机房容量
COMPUTER_NUM = 21


# 生成考场数据
def create_data(ls_dates_and_times, ls_class_rooms, COMPUTER_NUM):
    ls_data = []
    times = 0
    for date_and_time in ls_dates_and_times:
        # 场次号
        times += 1
        print(times)
        for class_room in ls_class_rooms:
            for i in range(COMPUTER_NUM):
                ls = []
                ls.append(f'{i + 1}')
                ls.append(f'第{times}场')
                ls.append(class_room)
                ls.append(date_and_time)
                ls_data.append(ls)
    return ls_data


ls_data = create_data(ls_dates_and_times, ls_class_rooms, COMPUTER_NUM)
ls_title = ['座位号', '场次号', '考场号', '考试日期时间']
df = pd.DataFrame(ls_data, columns=ls_title)
print(df)
writer = pd.ExcelWriter('计算机应用基础模板.xlsx')
df.to_excel(writer, '计算机应用基础模板', index=False)
print('ok')
writer.save()