#!/usr/bin/env python #coding: utf-8 import os from time import time from datetime import datetime from netmiko import ConnectHandler from openpyxl import Workbook from openpyxl import load_workbook def read_device_excel( ): ip_list = [] wb1 = load_workbook('E:\/Users/Wayne_Peng/Desktop/cs_lab.xlsx') ws1 = wb1.get_sheet_by_name("Sheet1") for cow_num in range(2,ws1.max_row+1): ipaddr = ws1["a"+str(cow_num)].value ip_list.append(ipaddr) return ip_list def get_config(ipaddr): session = ConnectHandler(device_type="huawei", ip=ipaddr, username="mtlops", password="cisco,123", banner_timeout=300) print("connecting to "+ ipaddr) print ("---- Getting HUAWEI configuration from {}-----------".format(ipaddr)) # config_data = session.send_command('screen-length 0 temporary') # config_data = session.send_command('dis cu | no-more ') # command = 'display version | display cpu-usage | display memory-usage' # config_data = session.send_command(command) commands = ['display version', 'display cpu-usage', 'display memory-usage'] config_data = '' for cmd in commands: output = session.send_command_timing(cmd) config_data += f'{cmd}\n{output}\n' session.disconnect() return config_data def write_config_to_file(config_data,ipaddr): now = datetime.now() date= "%s-%s-%s"%(now.year,now.month,now.day) time_now = "%s-%s"%(now.hour,now.minute) #---- Write out configuration information to file config_path = 'E:\/Users/Wayne_Peng/Desktop/' +date verify_path = os.path.exists(config_path) if not verify_path: os.makedirs(config_path) config_filename = config_path+"/"+'config_' + ipaddr +"_"+date+"_" + time_now # Important - create unique configuration file name print ('---- Writing configuration: ', config_filename) with open( config_filename, "w",encoding='utf-8' ) as config_out: config_out.write( config_data ) return def main(): starting_time = time() ip_list = read_device_excel() for ipaddr in ip_list: hwconfig = get_config(ipaddr) write_config_to_file(hwconfig,ipaddr) print ('\n---- End get config threading, elapsed time=', time() - starting_time) #======================================== # Get config of HUAWEI #======================================== if __name__ == '__main__': main() 加一段gevent，def run_gevent(）

好的，可以尝试这样写：

#!/usr/bin/env python
#coding: utf-8

import os
from time import time
from datetime import datetime
from netmiko import ConnectHandler
from openpyxl import Workbook
from openpyxl import load_workbook
import gevent
from gevent import monkey
monkey.patch_all()

def read_device_excel():
    ip_list = []
    wb1 = load_workbook('E:\/Users/Wayne_Peng/Desktop/cs_lab.xlsx')
    ws1 = wb1.get_sheet_by_name("Sheet1")
    for cow_num in range(2,ws1.max_row+1):
        ipaddr = ws1["a"+str(cow_num)].value
        ip_list.append(ipaddr)
    return ip_list

def get_config(ipaddr):
    session = ConnectHandler(device_type="huawei",
                             ip=ipaddr,
                             username="mtlops",
                             password="cisco,123",
                             banner_timeout=300)
    print("connecting to "+ ipaddr)
    print ("---- Getting HUAWEI configuration from {}-----------".format(ipaddr))
    commands = ['display version', 'display cpu-usage', 'display memory-usage']
    config_data = ''
    for cmd in commands:
        output = session.send_command_timing(cmd)
        config_data += f'{cmd}\n{output}\n'
    session.disconnect()
    return config_data

def write_config_to_file(config_data,ipaddr):
    now = datetime.now()
    date= "%s-%s-%s"%(now.year,now.month,now.day)
    time_now = "%s-%s"%(now.hour,now.minute)

    #---- Write out configuration information to file
    config_path = 'E:\/Users/Wayne_Peng/Desktop/' +date
    verify_path = os.path.exists(config_path)
    if not verify_path:
        os.makedirs(config_path)
    config_filename = config_path+"/"+'config_' + ipaddr +"_"+date+"_" + time_now # Important - create unique configuration file name
    print ('---- Writing configuration: ', config_filename)
    with open( config_filename, "w",encoding='utf-8' ) as config_out:
          config_out.write( config_data )
    return

def run_gevent(ip_list):
    jobs = []
    for ipaddr in ip_list:
        jobs.append(gevent.spawn(get_config, ipaddr))

    gevent.joinall(jobs)

    for job, ipaddr in zip(jobs, ip_list):
        hwconfig = job.value
        write_config_to_file(hwconfig,ipaddr)

    print('\n---- End get config threading')

def main():
    starting_time = time()
    ip_list = read_device_excel()
    run_gevent(ip_list)
    print('elapsed time:', time() - starting_time)

#========================================
# Get config of HUAWEI
#========================================
if __name__ == '__main__':
    main()

注意，这里使用了 `gevent` 库，需要先安装。可以在命令行中使用 `pip install gevent` 进行安装。