How to loop through excel form to create VLANS python

NetworkStuffGuy — Thu, 24 Mar 2022 18:13:04 GMT

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")

Re: How to loop through excel form to create VLANS python

aleabrahao — Thu, 24 Mar 2022 20:14:30 GMT

Check this link https://github.com/CiscoDevNet/meraki-network-vlan-provision

Re: How to loop through excel form to create VLANS python

NetworkStuffGuy — Thu, 24 Mar 2022 21:41:23 GMT

certainly helps, thank you!

topic How to loop through excel form to create VLANS python in Network Platform API

How to loop through excel form to create VLANS python

Re: How to loop through excel form to create VLANS python

Re: How to loop through excel form to create VLANS python