python xml转excel_一个python 脚本将XML文件转换到excel

需要下载一个module：xlwt，如下是source code

import xml.dom.minidom

import xlwt

import sys

col = 0

row = 0

def handle_xml_report(xml_report, excel):

problems = xml_report.getElementsByTagName("problem")

handle_problems(problems, excel)

def handle_problems(problems, excel):

for problem in problems:

handle_problem(problem, excel)

def handle_problem(problem, excel):

global row

global col

code = problem.getElementsByTagName("code")

file = problem.getElementsByTagName("file")

line = problem.getElementsByTagName("line")

message   = problem.getElementsByTagName("message")

for node in code:

excel.write(row, col, node.firstChild.data)

col = col + 1

for node in file:

excel.write(ro