51Testing软件测试论坛
标题:
QTP 如何输出Report中Object,Details等
[打印本页]
作者:
tianchuncheng
时间:
2014-4-30 16:17
标题:
QTP 如何输出Report中Object,Details等
[attach]90004[/attach] 如图想把Object,Details,Time,Result等输出到Excel中,如何获取这些值呢?
作者:
黑羽祭
时间:
2014-5-7 11:24
回复
1#
tianchuncheng
在脚本中直接获取,然后自己写脚本写入Excel比如:
Public Function QTP_Write_Excel(pathway,sheetname,x,y,content)
Dim srcData,srcDoc,sp1,sp2,num,use,a1,a2,a3
set srcData = CreateObject("Excel.Application")
srcData.Visible = False
set srcDoc = srcData.Workbooks.Open(pathway)
srcDoc.Worksheets(sheetname).Activate
srcDoc.Worksheets(sheetname).Cells(x,y).value = content
wait(1)
srcDoc.Save
srcData.Workbooks.Close
Set srcDoc = nothing
Window("text:=Microsoft Excel").Close
End Function
复制代码
作者:
tianchuncheng
时间:
2014-6-27 17:24
回复
2#
黑羽祭
非常感谢
欢迎光临 51Testing软件测试论坛 (http://bbs.51testing.com/)
Powered by Discuz! X3.2