import openpyxl
import os

row_number_int = 6

def folder_creation():

    os.chdir('C:\\Users\\Karsten\\OneDrive\\Hunter Group')

    wb = openpyxl.load_workbook('drawings.xlsx')

    print(type(wb))

    sheet = wb.get_sheet_by_name('Sheet1')

    row_number = str(row_number_int)

    c_row = 'C' + row_number
    g_row = 'G' + row_number

    print(c_row)
    print(g_row)

    title_code = sheet[c_row].value
    title_text = sheet[g_row].value

    document_category = title_code[:-3]
    print(document_category)


    title_text = title_text.capitalize()
    title_text = title_text.replace('&', '+')
    title_text = title_text.replace('/', '-')
    title_text = title_text.replace('(', ' - ')
    title_text = title_text.replace(')', '')

    folder_name = title_code + ' - ' + title_text
    print(folder_name)

    if os.path.exists('C:\\Users\\Karsten\\OneDrive\\Hunter Group\\folders\\' + document_category):
        print('That folder already exists')
    else:
        os.makedirs('C:\\Users\\Karsten\\OneDrive\\Hunter Group\\folders\\' + document_category)


    if os.path.exists('C:\\Users\\Karsten\\OneDrive\\Hunter Group\\folders\\' + document_category + '\\' + folder_name):
        print('That folder already exists')
    else:
        os.makedirs('C:\\Users\\Karsten\\OneDrive\\Hunter Group\\folders\\' + document_category + '\\' + folder_name)



while row_number_int < 369:
    folder_creation()
    row_number_int = row_number_int + 1