Being a lazy networking guy - Accessing Excel data from Python
Most of the time during the initial network design stage I keep lots of data in Excel. While implementation usually do manual work to extract the data from excel and convert it as CLI configuration. following example I've simulated to create the interface description from the data i've populated in excel. Following tools required in windows : (if you are a Linux guy most probably not reading this :) ) you can find the python windows executable in following URL : Python download link I'm using notepad++ with PyNPP , you can install this from plugin manager. you need to edit the python location in PyNPP option. Installing openpyxl is quite easy on Windows, you can find pip at C:\Python34\Scripts\pip.exe just run following command to install openpyxl "C:\Python34\Scripts> pip install openpyxl " You can do lot of stuff your imagination is the limit . have a look on the openpyxl import openpyxl wb = openpyxl.load_workbook('test.xlsx') sheets