Micro Focus QTP (UFT) Forums
Get and set data from specific cell in excel data file - 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: Get and set data from specific cell in excel data file (/Thread-Get-and-set-data-from-specific-cell-in-excel-data-file)



Get and set data from specific cell in excel data file - rushil - 12-05-2012

1.How do I get data from a specific cell in the excel datat file?
2. I am trying to set data in an excel file using the for loop. I have data in the excel file. I need data in the data in the following cells to be changed. (1,1); (2,2); (3,3)
Any help please?


RE: Get and set data from specific cell in excel data file - Ankesh - 12-05-2012

Hi,

Please go through the below links. There are lot of information available.

https://www.learnqtp.com/qtp-and-excel-part1/
https://www.learnqtp.com/qtp-and-excel-part2/
https://www.learnqtp.com/qtp-and-excel-part3/

Let me know if you still need help.

Regards,
Ankesh


RE: Get and set data from specific cell in excel data file - rushil - 12-06-2012

Thank you


RE: Get and set data from specific cell in excel data file - pKrishna - 01-04-2013

Hi The Image in Part 3 is not clear.