用excel里的一列数据作为文件夹的命名，生成文件夹

import os,pandas as pd
file_path='F:\Goprogram\python_code\company_information.xlsx'
xlsx_file=pd.read_excel(file_path,usecols=['id'])#需要做成文件夹的列名
main_folder='F:\Goprogram\python_code\main_folder'
if not os.path.exists(main_folder):
    os.mkdir(main_folder)
for row in xlsx_file.itertuples():
    try:
        name=str(getattr(row,'id'))
        print(name.zfill(6))
        os.mkdir(os.path.join(main_folder,name.zfill(6)))
    except:
        continue