Hey peeps, Im fairly new to scripting. I am working on a Python script to create VLANs based on the data in a excel form. I am not completely sure how to go about this. How would I go about pulling site names and then uploading the row of data relevant to that site name? You can see this is a broken script. "Net name" is referencing a range of cells in colum A which contain "Site name". This actually gives a tupel error. Create VLAN: Name, ID etc. Reference a single cell currently. (this was my test). But now i need it to reference the data in the row next to "site name" Id appreciate any direction here. Anything i should study or thought process etc. Still new, sorry for the painfully basic question. import meraki import openpyxl from openpyxl import Workbook, load_workbook API_KEY = ***** wb = load_workbook('test-excel.xlsx') ws = wb.active dashboard = meraki.DashboardAPI(API_KEY) myOrgs = dashboard.organizations.getOrganizations() net_name = ws['A2':'A4'] for row in net_name: net_name = row + 1 #gets and defines the ORG ID for theOrg in myOrgs: if theOrg['name'] == "ORG NAME": my_org = int(theOrg['id']) #Gets network ID from ORG and saves as variable named network_id my_networks = dashboard.organizations.getOrganizationNetworks(my_org, total_pages='all') for net in my_networks: if net["name"] == net_name: network_id = net["id"] #Create a new VLAN from your input network vlan = dashboard.appliance.createNetworkApplianceVlan( network_id, id=ws['B2'].value, name=ws['C2'].value, applianceIp=ws['D2'].value, subnet=ws['E2'].value) print("Done")
... View more