I dont know how to export entire result file into excel format. But I
would do something like that..
Suppose you are checking pass and fail scenario of something exist'
than
IF object.Exist(1) Then
DataTable("Operation",dtLocalSheet)="Name of Object"
DataTable("Result",dtLocalSheet)="Pass"
Else
DataTable("Operation",dtLocalSheet)="Name of Object"
DataTable("Result",dtLocalSheet)="Fail"
End IF
DataTable.ExportSheet "c:\test.xls"
Above code you can write in function and change 'column name' and
variable you want to call. You also need to provide 'setcurrent row'
for excel sheet so you are not over writing your result.
On Jan 14, 11:56 am, Madhan Kumar Mohan <[email protected]>
wrote:
> Hi Everybody,
>
> Please provide the script to export the QTP results to excel sheet
> using VB script.
>
> Thanks in advance!!!
--
You received this message because you are subscribed to the Google
"QTP - HP Quick Test Professional - Automated Software Testing"
group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/MercuryQTP?hl=en
