python netmiko库H3C交换机自动化,openpyxl读取Excel xlsx中的IP地址信息

电玩女神 2023-10-03 08:15 2阅读 0赞

from netmiko import *
    import openpyxl
    
    
    def ssh_SW(name, ip):
        try:
            S5130 = {
                'device_type': 'hp_comware',
                'ip': ip,
                'username': 'h3c',
                'password': 'h3c',
            }
            net_connect = ConnectHandler(**S5130)
    
            cmd = 'disp cu'
            cmd_result = net_connect.send_command(cmd)
            print('-----------------------------------------------------------------')
            print(cmd)
            print(cmd_result)
            print('-----------------------------------------------------------------')
            print('')
            net_connect.disconnect()
        except (EOFError, NetMikoTimeoutException):
            print('Can not connect to Device')
        except (EOFError, NetMikoAuthenticationException):
            print('username/password wrong!')
    
    
    def main():
        workbook = openpyxl.load_workbook('sw.xlsx')
        sheet = workbook["Sheet1"]
    
        for row in range(2, sheet.max_row + 1):
            name = sheet['A' + str(row)].value
            ip = sheet['B' + str(row)].value
            print(name)
            print(ip)
            ssh_SW(name, ip)
    
    
    if __name__ == "__main__":
        main()

sw.xlsx