python交换机巡检脚本_[Python]网络设备巡检脚本.pdf

python交换机巡检脚本_[Python]⽹络设备巡检脚本 #!/usr/bin/env python # -*- coding:utf-8 -*- #import sys #reload(sys) import xlsxwriter,os,datetime def cmd(sname,fname):#该函数判断巡检命令⾏所在输出⽂件位置 i=1 f=open(fname) line_hang_list=[] for line in f: if line.find(sname) == 0: line_hang_list.append(i) i+=1 f.close return line_hang_list def cmd1(sname,fname):#同上 i=1 f=open(fname) line_hang_list=[] for line in f: if sname in line: line_hang_list.append(i) i+=1 f.close return line_hang_list tday=datetime.date.today().strftime(%Y.%m.%d) today=datetime.date.today().strftime(%Y%m%d) workbook=xlsxwriter.Workbook(u/usr/sh/shell/linux/xunjian/%s/⽹络设备巡检-%s.xlsx%(today,tday), {strings_to_numbers:True}) file_01=/usr/sh/shell/linux/xunjian/+str(today)+/01DMZ-E8000E.txt file_02_1=/usr/sh/shell/linux/xunjian/+str(today)+/03SM-M9006.txt file_02_2=/usr/sh/shell/linux/xunjian/+str(today)+/02DMZ-M9006.txt file_03=/usr/sh/shell/linux/xunjian/+str(today)+/04IN-FG3950B.txt #新建sheet worksheet0=workbook.add_worksheet(u防⽕墙) worksheet1=workbook.add_worksheet(u交换机) worksheet2=workbook.add_worksheet(u路由器) worksheet3=workbook.add_worksheet(u负载) #设置单元格格式(居中，颜⾊，边框，合并，列宽，列隐藏等) colour=#660099 format_title=workbook.add_format() format_title.set_border(1) format_title.set_bottom(2) format_title.set_bold(1) format_title.set_font_color(white) format_title.set_bg_color(colour) format_title.set_align(center) format_title.set_valign(vcenter) format_nr=workbook.add_format() format_nr.set_border(1) format_nr.set_bottom(2) format_nr.set_align(center) format_nr.set_valign(vcenter) format_nrr=workbook.add_format() format_nrr.set_border(1) format_nrr.set_valign(vcenter) format_nrr.set_text_wrap() format_bottom=workbook.add_format() format_bottom.set_border(1) format_bottom.set_bottom(2) format_bottom.set_valign(vcenter) format_bottom.set_text_wrap() format_rt=workbook.add_format() format_rt.set_border(1) format_rt.set_right(2) format_rt.set_valign(left) format