我就废话不多说了,大家还是直接看代码吧~
#!/usr/bin/python
# -*- coding: utf-8 -*-
import xlwt
import re
def host_regex(dataline):
host_regex = r"(.*?)"
host = re.findall(host_regex, dataline)
if host:
return host[0]
def ip_regex(dataline):
ip_regex = r"(.*?)"
ip = re.findall(ip_regex, dataline)
if ip:
return ip[0]
with open("zbx_export_hosts.xml", "r", encoding="utf8") as f:
lines = f.readlines()
alldatas = []
hostlist = []
iplist = []
for line in lines:
host = host_regex(line)
ip = ip_regex(line)
if host is not None:
hostlist.append(host)
if ip is not None:
iplist.append(ip)
hosts_ip = []
# 构造数据结构,形如:[[a,b],[c,d],...]
multi_list = map(list, zip(hostlist, iplist))