+- 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: Importing data from excel sheet (/Thread-Importing-data-from-excel-sheet)
Importing data from excel sheet - ankianand88 - 02-18-2011
Hi,
I am new to QTP. I was trying to automate to fetch data from excel sheet but the excel sheet is having filter in it. For eg. the excel sheet consists of teacher's name and the subject she teaches.
now what i need to do is like i want all the teacher's name corresponding to one subject be fetched, then second and so on, using filter.
Hope my question is clear
Can anyone please help me on this?
RE: Importing data from excel sheet - Rohan - 02-18-2011
Hi,
You can do this by establishing ADODB connection with the Excel sheet, then frame a query according
your requirement-->Execute the Query. Import it then, This is just for your idea. Ill look into it and post you helpful code.
RE: Importing data from excel sheet - ankianand88 - 02-21-2011
Hi this is not working....did it worked for you?