#coding=utf8from xml.dom import minidomfrom excute_excel import executeExel #自己写的模块class Xml():def getxml(self):#打开xml文档dom = minidom.parse(r'testsuite-deep.xml')#用于得到dom对象的文档元素，并把获得的对象给rootroot = dom.documentElement#可以使用getElementsByTagName方法获取元素itemlist = root.getElementsByTagName('testcase')row =1for i in itemlist:#getAttribute方法可以获得元素的属性所对应的值name= i.getAttribute('name')actions = i.getElementsByTagName('actions')expectedresults = i.getElementsByTagName('expectedresults')preconditions = i.getElementsByTagName('preconditions')plist = []for pre in preconditions:# childNodes返回子节点的一个列表，如果子节点有值，则进行如下操作if len(pre.childNodes)>0:# 获取第一个子节点的数据p = str(pre.childNodes[0].data)#将输出的一些字符清楚pre = p.replace('<p>', '').replace('tab', '').\replace('</p>', '').replace('\n', '').replace('<br />', '')plist.append(pre)precontent = '\n'.join(plist)print(precontent)list = []for action in actions:#childNodes返回子节点的一个列表，如果子节点有值，则进行如下操作if len(action.childNodes)>0:#获取第一个子节点的数据a = str(action.childNodes[0].data)a = a.replace('<p>','').replace('tab','').replace('</p>','').replace('\n','') \.replace('<br />', '')list.append(a)else:passstep = '\n'.join(list)elist = []for expectedresult in expectedresults:if len(expectedresult.childNodes)>0:m = str(expectedresult.childNodes[0].data)m = m.replace('<p>', '').replace('tab', '').replace('</p>', '').replace('\n', '')\.replace('<br />','')elist.append(m)else:passexpect = '\n'.join(elist)try:excel = executeExel('web.xls')excel.write_exist_excel_result(row, 0,precontent)excel.write_exist_excel_result(row,2,name)excel.write_exist_excel_result(row, 3, step)excel.write_exist_excel_result(row, 4, expect)row += 1except Exception as e:print(e)if __name__ == '__main__':xm = Xml()xm.getxml()
