Python-Excel-openpyxl-08-读Excel生成文件夹

import os
from openpyxl import load_workbook

excel_address = r"E:\Coding\E_PythonWriting\Excel\openpyxl示例_8_学员信息.xlsx"
wb = load_workbook(excel_address)
sht = wb.worksheets[0]

max_row = sht.max_row

root_folder_address = r"E:\Coding\E_PythonWriting\Excel\学员档案"

# 获取学员信息
for i in range(2, max_row+1):
    student_num = sht["A"+str(i)].value
    student_name = sht["B" + str(i)].value
    if student_num:
        folder_name = "{0}+{1}".format(student_num, student_name)
        folder_address = os.path.join(root_folder_address, folder_name)
        if not os.path.exists(folder_address):
            os.mkdir(folder_address)