python 循环写入excel_Python 使用xlwt模块将多行多列数据循环写入excel文档的操作...

我就废话不多说了，大家还是直接看代码吧~

#!/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))