最近在使用Testlink時(shí),發(fā)現(xiàn)導(dǎo)入的用例是xml格式,且沒有合適的工具轉(zhuǎn)成excel格式,xml使用excel打開顯示的東西也太多,網(wǎng)上也有相關(guān)工具轉(zhuǎn)成csv格式的,結(jié)果也不合人意。
那求人不如爾己,自己寫一個(gè)吧
需要用到的模塊有:xml.dom.minidom(python自帶)、xlwt
使用版本:
python:2.7.5
xlwt:1.0.0
一、先分析Testlink XML格式:
這是一個(gè)有兩級testusuit的典型的testlink用例結(jié)構(gòu),我們只需要取testsuite name,testcase name,preconditions,actions,expectedresults
二、程序如下:
#coding:utf-8
'''
Created on 2015-8-20
@author: Administrator
'''
'''
'''
import xml.etree.cElementTree as ET
import xml.dom.minidom as xx
import os,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\test.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: wrap on,vert centre, horiz center') #自動(dòng)換行、水平居中、垂直居中
#設(shè)置標(biāo)題的格式,字體方宋、加粗、背景色:菊黃
#測試項(xiàng)的標(biāo)題
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='測試項(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
#一級目錄
for i in root.childNodes:
testsuite=i.getAttribute('name').strip()
#print testsuite
#print testsuite
'''
寫測試項(xiàng)
'''
print "row is :",row
booksheet.write(row,col,testsuite,style)
#二級目錄
for dd in i.childNodes:
print " %s" % dd.getAttribute('name')
testsuite2=dd.getAttribute('name')
if not dd.getElementsByTagName('testcase'):
print "Testcase is %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')
for subb in itemlist:
#print " %s" % subb.getAttribute('name')
testcase=subb.getAttribute('name')
row=row+1
booksheet.write(row,2,testcase,style)
ilist=subb.getElementsByTagName('preconditions')
for ii in ilist:
preconditions=ii.firstChild.data.replace("
"," ")
col=col+1
booksheet.write(row,3,preconditions,style)
steplist=subb.getElementsByTagName('actions')
#print steplist
for step in steplist:
actions=step.firstChild.data.replace("
"," ")
col=col+1
booksheet.write(row,4,actions,style)
#print "測試步驟:",steplist[0].firstChild.data.replace("
"," ")
expectlist=subb.getElementsByTagName('expectedresults')
for expect in expectlist:
result=expect.childNodes[0].nodeValue.replace("
","" )
booksheet.write(row,5,result,style)
row=row+1
workbook.save('demo.xls')
寫入excel的效果如下:
我們再來看個(gè)實(shí)例:
需要下載一個(gè)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)
更多文章、技術(shù)交流、商務(wù)合作、聯(lián)系博主
微信掃碼或搜索:z360901061
微信掃一掃加我為好友
QQ號(hào)聯(lián)系: 360901061
您的支持是博主寫作最大的動(dòng)力,如果您喜歡我的文章,感覺我的文章對您有幫助,請用微信掃描下面二維碼支持博主2元、5元、10元、20元等您想捐的金額吧,狠狠點(diǎn)擊下面給點(diǎn)支持吧,站長非常感激您!手機(jī)微信長按不能支付解決辦法:請將微信支付二維碼保存到相冊,切換到微信,然后點(diǎn)擊微信右上角掃一掃功能,選擇支付二維碼完成支付。
【本文對您有幫助就好】元

