最近在使用Testlink时，发现导入的用例是xml格式，且没有合适的工具转成Excel格式，xml使用excel打开显示的东西也太多，网上也有相关工具转成csv格式的，结果也不合人意。
那求人不如尔己，自己写一个吧
需要用到的模块有：xml.dom.minidom(python自带)、xlwt
使用版本：
python:2.7.5
xlwt:1.0.0
一、先分析Testlink XML格式：
这是一个有两级testusuit的典型的testlink用例结构，我们只需要取testsuite name,testcase name，PReconditions，actions，expectedresults
二、程序如下：
#coding:utf-8'''Created on 2015-8-20
@author: Administrator'''''''''importxml.etree.cElementTree as ETimportxml.dom.minidom as xximportos,xlwt,datetime
workbook=xlwt.Workbook(encoding="utf-8")#booksheet=workbook.add_sheet(u'sheet_1')
booksheet.col(0).width= 5120booksheet.col(1).width= 5120booksheet.col(2).width= 5120booksheet.col(3).width= 5120booksheet.col(4).width= 5120booksheet.col(5).width= 5120dom=xx.parse(r'D:\\Python27\test.xml')
root=dom.documentElement
row=1col=1borders=xlwt.Borders()
borders.left=1borders.right=1borders.top=1borders.bottom=1style= xlwt.easyxf('align: wrap on,vert centre, horiz center') #自动换行、水平居中、垂直居中#设置标题的格式，字体方宋、加粗、背景色：菊黄
#测试项的标题
title=xlwt.easyxf(u'font:name 仿宋,height 240 ,colour_index black, bold on, italic off; align: wrap on, vert centre, horiz center;pattern: pattern solid, fore_colour light_orange;')
item='测试项'Subitem='测试分项'CaseTitle='测试用例标题'Condition='预置条件'actions='操作步骤'Result='预期结果'booksheet.write(0,0,item,title)
booksheet.write(0,1,Subitem,title)
booksheet.write(0,2,CaseTitle,title)
booksheet.write(0,3,Condition,title)
booksheet.write(0,4,actions,title)
booksheet.write(0,5,Result,title)#冻结首行booksheet.panes_frozen=True
booksheet.horz_split_pos= 1#一级目录foriinroot.childNodes:
testsuite=i.getAttribute('name').strip()#print testsuite#print testsuite'''写测试项'''print"row is :",row
booksheet.write(row,col,testsuite,style)#二级目录forddini.childNodes:print"%s"% dd.getAttribute('name')
testsuite2=dd.getAttribute('name')ifnotdd.getElementsByTagName('testcase'):print"Testcase is %s"%testsuite2
row=row+1booksheet.write(row,2,testsuite2,style) #写测试分项
row=row+1booksheet.write(row,1,testsuite2,style)
itemlist=dd.getElementsByTagName('testcase')forsubbinitemlist:#print " %s" % subb.getAttribute('name')testcase=subb.getAttribute('name')row=row+1booksheet.write(row,2,testcase,style)
ilist=subb.getElementsByTagName('preconditions')foriiinilist:
preconditions=ii.firstChild.data.replace("<br />","")
col=col+1booksheet.write(row,3,preconditions,style)
steplist=subb.getElementsByTagName('actions')#print steplistforstepinsteplist:
actions=step.firstChild.data.replace("<br />","")
col=col+1booksheet.write(row,4,actions,style)#print "测试步骤：",steplist[0].firstChild.data.replace("<br />"," ")expectlist=subb.getElementsByTagName('expectedresults')forexpectinexpectlist:
result=expect.childNodes[0].nodeValue.replace("<br />","")
booksheet.write(row,5,result,style)
row=row+1workbook.save('demo.xls')
写入excel的效果如下：
参考文档：
1、python对excel操作：http://www.open-open.com/lib/view/open1385174954276.html
2、python之xml操作:http://www.jb51.net/article/63780.htm