一、先分析TestlinkXML格式：
這是一個(gè)有兩級testusuit的典型的testlink用例結(jié)構(gòu)，我們只需要取testsuitename，testcasename，preconditions，actions，expectedresults
二、程序如下：
#coding:utf-8
'''
Createdon2015-8-20
@author:Administrator
'''
'''
'''
importxml.etree.cElementTreeasET
importxml.dom.minidomasxx
importos，xlwt，datetime
workbook=xlwt.Workbook(encoding="utf-8")
#
booksheet=workbook.add_sheet(u'sheet_1')
booksheet.col(0).width=5120
booksheet.col(1).width=5120
booksheet.col(2).width=5120
booksheet.col(3).width=5120
booksheet.col(4).width=5120
booksheet.col(5).width=5120
dom=xx.parse(r'D:\Python27 est.xml')
root=dom.documentElement
row=1
col=1
borders=xlwt.Borders()
borders.left=1
borders.right=1
borders.top=1
borders.bottom=1
style=xlwt.easyxf('align:wrapon，vertcentre，horizcenter')#自動換行、水平居中、垂直居中
#設(shè)置標(biāo)題的格式，字體方宋、加粗、背景色：菊黃
#測試項(xiàng)的標(biāo)題
title=xlwt.easyxf(u'font:name仿宋，height240，colour_indexblack，boldon，italicoff;align:wrapon，vertcentre，horizcenter;pattern:patternsolid，fore_colourlight_orange;')
item='測試項(xiàng)'
Subitem='測試分項(xiàng)'
CaseTitle='測試用例標(biāo)題'
Condition='預(yù)置條件'
actions='操作步驟'
Result='預(yù)期結(jié)果'
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)
#凍結(jié)首行
booksheet.panes_frozen=True
booksheet.horz_split_pos=1
#一級目錄
foriinroot.childNodes:
testsuite=i.getAttribute('name').strip()
#printtestsuite
#printtestsuite
'''
寫測試項(xiàng)
'''
print"rowis:"，row
booksheet.write(row，col，testsuite，style)
#二級目錄
forddini.childNodes:
print"%s"%dd.getAttribute('name')
testsuite2=dd.getAttribute('name')
ifnotdd.getElementsByTagName('testcase'):
print"Testcaseis%s"%testsuite2
row=row+1
booksheet.write(row，2，testsuite2，style)#寫測試分項(xiàng)
row=row+1
booksheet.write(row，1，testsuite2，style)
itemlist=dd.getElementsByTagName('testcase')
forsubbinitemlist:
#print"%s"%subb.getAttribute('name')
testcase=subb.getAttribute('name')
row=row+1
booksheet.write(row，2，testcase，style)
ilist=subb.getElementsByTagName('preconditions')
foriiinilist:
preconditions=ii.firstChild.data.replace("<br/>"，"")
col=col+1
booksheet.write(row，3，preconditions，style)
steplist=subb.getElementsByTagName('actions')
#printsteplist
forstepinsteplist:
actions=step.firstChild.data.replace("<br/>"，"")
col=col+1
booksheet.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+1
workbook.save('demo.xls')
