批量创建文件夹
import os, sys
from os import walk, mkdir, rename, path
from shutil import copy, move
import time
from openpyxl import load_workbook
#批量创建文件夹
wb = load_workbook(‘staffinfo.xlsx’)
ws = wb[‘Sheet1’]
#注意这里ws.rows返回一个生成器对象
ws = [x for x in ws.rows]
for x in ws[1:]:
print(x[1].value, x[2].value)
os.mkdir(‘venv/company_staff/’+x[1].value)