Update Cisco APIC configuration directly from an Excel spreadsheet. There is no need to manually execute any scripts, and all interactions takes place through the use of buttons/macros.
Thanks to Carl Niger for publically sharing his .json library (which is used as part of this package): https://github.com/carlniger/acitool
How the control panel looks like:
How the tables appears:
An example of pushing a successful policy:
-
Unzip all contents into precise folder location: C:\acixl\
-
Install pywin32: https://sourceforge.net/projects/pywin32/files/pywin32/
-
Install the following modules:
- xlwings
- requests
- jinja2
-
From the command prompt, type: xlwings addin install
-
Open the excel file 'runsheet.xlsm'
-
Goto the visual basic editor -> tools -> references -> click xlwings
note. Tested on Windows 8.1 & Windows 10 using Excel 2016
- Open up runsheet.xlsm
- Under the APIC tab enter the apic controller IP, username and password
- Navigate to one of the worksheets, i.e. Tenant Policies or Fabric Access Policies
- Add as many rows as required under the relevant table
- Click the Test Authentication button to ensure connectivity to APIC
- Choose the command from the control panel and press the Select button
- Click the Push Configuration button
Update aci.py and change the following variables to reflect the new directory name:
-
JSON_ROOT_FOLDER
-
LAUNCHER_FILE
To change the name of the runsheet, update the WORKBOOK_NAME variable in excel.py, i.e.
WORKBOOK_NAME = 'newname.xlsm'
Send feature requests to [email protected]