excel_import_main.py

def main():
    wb = openpyxl.load_workbook(conf['excel_file'])
    name = wb.get_sheet_names()[0]
    sheet = wb.get_sheet_by_name(name)
    for row in range(2, sheet.max_row):  # from 2 (assuming first row contains headers) to end of the rows
        condition = sheet.cell(row=row, column=1).value
        color = sheet.cell(row=row, column=2).value
        year = sheet.cell(row=row, column=3).value
        name = sheet.cell(row=row, column=4).value
        description = sheet.cell(row=row, column=5).value
        body = sheet.cell(row=row, column=6).value
        notes = sheet.cell(row=row, column=7).value
        json_data = get_json(condition, color, year, name, description, body, notes)
        if name:
            asset_name = name.replace(" ", "_")
        else:
            break
        create_asset(json_data, asset_name)