Python Tool4:创建文件夹

创建

import os
 
def mkdir(path):
 
	folder = os.path.exists(path)
 
	if not folder:                   #判断是否存在文件夹如果不存在则创建为文件夹
		os.makedirs(path)            #makedirs 创建文件时如果路径不存在会创建这个路径
		print("---  new folder...  ---")
		print("---  OK  ---")
 
	else:
		print("---  There is this folder!  ---")
		
file = r"D:\视频\test"
mkdir(file)

创建

'''
Description: henggao_note
version: v1.0.0
Date: 2022-06-25 18:25:03
LastEditors: henggao
LastEditTime: 2022-06-25 23:25:29
'''
import os
import openpyxl

file = "D:\\桌面\\2022年暑假留校学生情况统计表_ghg.xlsx"
# file = r'D:\PYTHON\openpyxl_read_write\\数据管理系统.xlsx'

workbook1=openpyxl.load_workbook(file)
#选定目标sheet
worksheet1 = workbook1.active
col_A = []
col_B= []
col_C= []
for cell in worksheet1['B']:
    # print(cell.value)
    col_B.append(cell.value)
for cell in worksheet1['C']:
    # print(cell.value)
    col_C.append(cell.value)

 
def mkdir(path):
	folder = os.path.exists(path) 
	if not folder:                   #判断是否存在文件夹如果不存在则创建为文件夹
		os.makedirs(path)            #makedirs 创建文件时如果路径不存在会创建这个路径
		print("---  new folder...  ---")
		print("---  OK  ---")
	else:
		print("---  There is this folder!  ---")

# print(len(col_B))
i = 0
while i < len(col_B):
	# print(i)
	file = "D:\\视频\\test\\" + col_B[i] +"\\"+ col_C[i] 
	i+=1
	print(file)
	mkdir(file)             #调用函数
    	

# file = r"D:\视频\test"
# mkdir(file)             #调用函数