QTP script convertion in excel

[deepaster]

Hi All,

How do we convert scripts of QTP to Excel format?
Please reply urgently.

thanks

[basanth27]

Deepaster -
I fail miserably to understand your question. Would appreciate if you can provide finer details which will definitely help any layman to first understand the question and then analyzing and finally ending with a reply.

[abhijitp]

Urgent.......
Anybody..! Can you please help me.....

Actualy I want to export all the values of a dropdown list in Excel file.
Here my code snippet attached below....

Code:

dim cnt
cnt  = Window("Flight Reservation").WinComboBox("Fly From:").GetItemsCount     '''Select "Denver"
MsgBox cnt
For i=0 to cnt-1
    Dim itm
    itm = Window("Flight Reservation").WinComboBox("Fly From:").GetItem(i)
    
    DataTable.AddSheet ("Fly From").AddParameter "Fly From", itm    DataTable.GetSheet("Fly From").SetNextRow
    datatable.ExportSheet "C:\Users\abhijitp\Desktop\result.xls", "Fly From"
    MsgBox itm
Next

But the problem is....values are being added in same row and different column. But I want to add these values in same column.
Please help me to do it.

---

Please help me to post new thread....
I have subcribed with User Name and password. But I could not find out any link to post new thread.

[deepaster]

hi,
Is there a way of converting the recorded script in qtp to excel sheet?
Like in selenium we can directly save the test script in excel format.

thanks

[basanth27]

Nope. Not possible.

[deepaster]

thanks for your prompt response
now will have to do some coding for the same i guess.
I have another query:
Can we customize the test results produced by QTP? or the only solution is to use Test Management Tool (Quality Centre) for the graphs and all?