Micro Focus QTP (UFT) Forums
How to pass data from external file (.xls) from particular sheet at run time - 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: How to pass data from external file (.xls) from particular sheet at run time (/Thread-How-to-pass-data-from-external-file-xls-from-particular-sheet-at-run-time)



How to pass data from external file (.xls) from particular sheet at run time - Priya.Shah134 - 02-02-2010

I am using QTP 9.0 version for the automation. I have a below query :

I am passing the data from the external .xls file and the file has several sheets. In this case is it possible to instruct QTP to take the Data from the particular sheet at the run time ?

Thanks,
Priya


RE: How to pass data from external file (.xls) from particular sheet at run time - Saket - 02-02-2010

Yes, it will depend on how you are using the external xls in you script. if you do a import, try 'Datatable.ImportSheet'