QTP script convertion in excel

QTP script convertion in excel - Printable Version

+- Micro Focus QTP (UFT) Forums (https://www.learnqtp.com/forums)
+-- Forum: Micro Focus UFT (earlier known as QTP) (https://www.learnqtp.com/forums/Forum-Micro-Focus-UFT-earlier-known-as-QTP)
+--- Forum: UFT / QTP Beginners (https://www.learnqtp.com/forums/Forum-UFT-QTP-Beginners)
+--- Thread: QTP script convertion in excel (/Thread-QTP-script-convertion-in-excel)

QTP script convertion in excel - deepaster - 03-14-2011

Hi All,

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

thanks

RE: QTP script convertion in excel - basanth27 - 03-14-2011

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.

RE: QTP script convertion in excel - abhijitp - 03-14-2011

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.

RE: QTP script convertion in excel - deepaster - 03-15-2011

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

RE: QTP script convertion in excel - basanth27 - 03-15-2011

Nope. Not possible.

RE: QTP script convertion in excel - deepaster - 03-15-2011

thanks for your prompt response Smile

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?