二分队-写端口代码

最新推荐文章于 2024-10-10 22:09:09 发布

Guaiacum_

最新推荐文章于 2024-10-10 22:09:09 发布

阅读量323

点赞数 5

文章标签： python

本文链接：https://blog.csdn.net/u013184378/article/details/142714018

版权

def InterfaceToexcel():
    f=open('interface.txt','r',encoding='utf-8')
    lines = f.readlines()

    lines_str = "".join(lines)
    print(type(lines_str))
    wb = openpyxl.Workbook()
    ws = wb.active

    reslines = lines_str.split("\n")
    for line in reslines:
        if len(re.findall(r'Interface',line))>0:
            columns = re.split(r'\s+',line)
            columns = columns[0:8]
            ws.append(columns)

        regex = re.compile(r'GE.+\s+.+\s+.+\s+.+\s+.+\s+.+\s+.+',re.S)
        if len(re.findall(regex,line))>0:
            new_line = re.split(r'\s+',line)
            print(new_line)
            ws.append(new_line)
    wb.save("interfaceInfo.xlsx")

#InterfaceToexcel()

def OSPFtoExcel():
    f = open("ospf1.txt",'r',encoding='utf-8')
    lines = f.readlines()
    lines_str = "".join(lines)

    start_str = re.compile(r'Router ID (.+)')
    RouterID = re.search(start_str,lines_str).group(1)
    print(RouterID)

    start_str = re.compile(r'Area: (.+)')
    Area = re.search(start_str,lines_str).group(1).split(" ")[0]
    print(Area)

    start_str = re.compile(r'Hello (.+)')
    Hello = re.search(start_str,lines_str).group(1).split(" ")[0]
    print(Hello)

    start_str = re.compile(r'Dead (.+)')
    Dead = re.search(start_str, lines_str).group(1).split(" ")[0]
    print(Dead)

    return [RouterID,Area,Hello,Dead]

def toExcel():
    wb = openpyxl.Workbook()
    ws = wb.active
    ws.append(['RouterID','Area','Hello','Dead'])
    ws.append(OSPFtoExcel())
    wb.save("ospf.xlsx")