如何使用Python制作脚本巡检设备，并将结果输出到excel，值得参考！

import pexpect
import sys
import datetime
import openpyxl

# 定义交换机信息和命令
switch_info = {
    "ip": "x.x.x.x",
    "passwd": "xxxx",
    "name": "<F5-Core-S12508>",
    "name1": "---- More ----"
}

# 创建 Excel 工作簿和工作表
workbook = openpyxl.Workbook()
worksheet = workbook.active
worksheet.title = "Switch Inspection"

child = pexpect.spawn('telnet %s' % switch_info["ip"])
child.expect('login:')
child.sendline("admin")
child.expect('(?i)ssword:')
child.sendline(switch_info["passwd"])
child.expect(switch_info["name"])

# 执行命令并将输出写入 Excel
def execute_command(command):
    child.sendline(command)
    child.expect(switch_info["name1"])
    result = child.before.decode("utf-8")
    return result

# 执行各个命令并写入 Excel
commands = [
    "display power",
    "display version",
    "display environment",
    "display fan",
    "display cpu-usage",
    "display memory",
    "display interface brief",
    "dis logbuffer",
    "display ip routing-table",
    "display irf link",
]
for command in commands:
    output = execute_command(command)
    worksheet.append([command, output])

child.sendline("quit")
child.expect(pexpect.EOF)

# 保存 Excel 文件
excel_filename = f"switch_inspection_{datetime.date.today().strftime('%Y%m%d')}.xlsx"
workbook.save(excel_filename)
print(f"Inspection results saved to {excel_filename}")

pip install pexpect openpyxl