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

全栈程序员-用户IM • 2022年8月22日下午6:00 • 未分类

大家好，又见面了，我是你们的朋友全栈君。如果您正在找激活码,请点击查看最新教程,关注关注公众号 “全栈程序员社区” 获取激活教程,可能之前旧版本教程已经失效.最新Idea2022.1教程亲测有效,一键激活。

Jetbrains全系列IDE使用 1年只要46元售后保障童叟无欺

需要下载一个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(row, col, node.firstChild.data)

col = col + 1

for node in line:

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

col = col + 1

for node in message:

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

col = col + 1

row = row+1

col = 0

if __name__ == ‘__main__’: if(len(sys.argv) <= 1): print (“usage: xml2xls src_file [dst_file]”) exit(0) #the 1st argument is XML report ; the 2nd is XLS report if(len(sys.argv) == 2): xls_report = sys.argv[1][:-3] + ‘xls’ #if there are more than 2 arguments, only the 1st & 2nd make sense else: xls_report = sys.argv[2] xmldoc = xml.dom.minidom.parse(sys.argv[1]) wb = xlwt.Workbook() ws = wb.add_sheet(‘MOLint’) ws.write(row, col, ‘Error Code’) col = col + 1 ws.write(row, col, ‘file’) col = col + 1 ws.write(row, col, ‘line’) col = col + 1 ws.write(row, col, ‘Description’) row = row + 1 col = 0 handle_xml_report(xmldoc, ws) wb.save(xls_report)

发布者：全栈程序员-用户IM，转载请注明出处：https://javaforall.cn/171936.html原文链接：https://javaforall.cn

【正版授权，激活自己账号】： Jetbrains全家桶Ide使用，1年售后保障，每天仅需1毛

【官方授权正版激活】： 官方授权正版激活支持Jetbrains家族下所有IDE 使用个人JB账号...