采集会话信息

'''

python

import re
import openpyxl
from openpyxl import Workbook
wb=Workbook()
sheet=wb.active

patterns=(r" (\S+)  VPN: \S+ --> \S+  ID: \S+",
r" Create Time :\S+ \S+",
r" Zone: \S+ --> \S+ Slot: \d CPU: \S+ TTL: \S+  Left: \S+",
r" Interface: \S+ NextHop: \S+",
r" <[-=]{2}packets: (\d+) bytes: \S+ [-=]{2}> packets: (\d+) bytes: \S+",
r"  (\S+)\.(\S+) [+-]-> (\S+)\.(\S+) PolicyName: \S+"
          )
pattern = '\n'.join(patterns)
with open("1.txt","r") as f:
    lines=f.read()
    result=re.findall(pattern,lines)
for i in range(len(result)):
    sheet.append(result[i])
wb.save("result.xlsx")
'''