python 读取XML文件输出至excel

from xml.dom.minidom import parse
import xml.dom.minidom 
import os
import sys
import xlsxwriter
def readxml(name):
    rootpath = os.getcwd()
    path = os.path.join(rootpath,name)
    dom = xml.dom.minidom.parse(path)
    testResults = dom.documentElement
    requestlist = [['用例名称','请求入参','请求出参']]
    if testResults.hasAttribute("version"):
        print("测试版本 : %s" % testResults.getAttribute("version"))
        requestlist.insert(0,testResults.getAttribute("version"))
    testCases=testResults.getElementsByTagName('httpSample')
    for testCase in testCases:
        # if testCase.hasAttribute('lb'):
            # print ("用例名称: %s" % testCase.getAttribute("lb"))
        request = testCase.getElementsByTagName('queryString')
        # print("请求入参： %s" % request[0].childNodes[0].data)
        response = testCase.getElementsByTagName('responseData')
        # print("请求出参： %s" % response[0].childNodes[0].data)
        requestlist.append([testCase.getAttribute("lb"),request[0].childNodes[0].data,response[0].childNodes[0].data])
    return requestlist

def write_excel_xlsx(value):
    rootpath = os.getcwd()
    path = os.path.join(rootpath,'测试版本'+value[0]+'.xlsx')
    newxlsx = xlsxwriter.Workbook(path)
    newsheet = newxlsx.add_worksheet()
    for i in range(1,len(value)):
        for j in range(len(value[1])):
            newsheet.write(i-1,j,str(value[i][j]))
    newxlsx.close()
    print("xlsx格式表格写入数据成功！")

if __name__ == "__main__":
    write_excel_xlsx(readxml(sys.argv[1]))