Python mac address formatting mac#

The objective is to put all the MAC addresses against an interface in column 11. The above writes to the excel file but only the last MAC address against an interface. Ws.cell(row = x, column = 11, value=macaddress) Ws.cell(row = x, column = 9, value=interface) Ws.cell(row = x, column = 8, value=interface) Ws.cell(row = x, column = 7, value=switchserialnumber) Ws.cell(row = x, column = 6, value=switchsiteaddress) Ws.cell(row = x, column = 5, value=switchsitename) Ws.cell(row = x, column = 4, value=switchcountry) Ws.cell(row = x, column = 3, value=switchregion) Ws.cell(row = x, column = 2, value=switchaddress) Ws.cell(row = x, column = 1, value=switchname) Output2 = net_nd_command ('show mac address-table', use_textfsm = True) Output = net_nd_command ('show interfaces status', use_textfsm = True) If ws.cell(row=row, column=1).value = switchname: Wbwr = openpyxl.load_workbook('dot1x.xlsx') Logfile_open = open('dot1xLog - ' + str(actual_time) + '.txt', 'a') #Load the file portcounters to which the output will be written.Store the file in same directory where the script is or else define the path using oscwdДЄctual_time = strftime('%Y-%m-%d_%H-%M-%S')

Switch = ws.cell(row= row, column = 4).value Switch = ws.cell(row= row, column = 5).value Switch = ws.cell(row= row, column = 8).value Switch = ws.cell(row= row, column = 7).value

Switch = ws.cell(row= row, column = 3).value Switch = ws.cell(row= row, column = 2).value Switch = ws.cell(row= row, column = 1).value Wbswitches = openpyxl.load_workbook('switchenv1.xlsx') Store the file in same directory where the script is or else define the path using oscwd #Load the Switch inventory file which has switchname in column 1 and IP address in Column 2. Following is current code.ДЇrom netmiko import ConnectHandler,ssh_exception