Micro Focus QTP (UFT) Forums
How to use Excel sheet in the back end? - 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: VB Scripting/Descriptive Programming (https://www.learnqtp.com/forums/Forum-VB-Scripting-Descriptive-Programming)
+--- Thread: How to use Excel sheet in the back end? (/Thread-How-to-use-Excel-sheet-in-the-back-end)



How to use Excel sheet in the back end? - ttz - 09-08-2008

I would like to use Excel sheet for entering input to QTP?
I would also like to use SQL to extract the right info from the excel sheet? I have been try to work on this for long.I would like to know how to use OR effectively.I have always done Descriptive scripting only.
Kindly help me on this with effective examples.

Thanks and regards
TTZ


RE: How to use Excel sheet in the back end? - Ankur - 09-08-2008

I would like to use Excel sheet for entering input to QTP?

You can refer this post on how to retrieve data from excel sheet

I would also like to use SQL to extract the right info from the excel sheet? I have been try to work on this for long.
not sure what you mean by this as SQL is a query language which is used to query and retrieve data from DB's like Oracle, MS Access etc

I would like to know how to use OR effectively.I have always done Descriptive scripting only.
Kindly help me on this with effective examples.

You need to go through QTP blog thoroughly ...there are many posts covering this topic.