+- 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 - How to use another actions localsheet (/Thread-QTP-How-to-use-another-actions-localsheet)
QTP - How to use another actions localsheet - D2010 - 08-05-2010
If you have several reusable actions in a script, can they access the parameters from a different datasheet?
Say I have 3 reusable actions in a test script which contain several parameters in each. I know that some of the parameters needed in all three actions are generic so rather than enter them in each of the three actions, I’d like to just tell QTP which datasheet to get the parameter from (similar to what you can do in excel).
I know I could use the global datasheet rather than localsheets, but the volume of parameters would make the global datasheet “messy”. So I hoping there is a way to simply define which datasheet to look at.
Anyone know how to do this? (if it can be done at all).
Thanks in advance for any help on this.
RE: QTP - How to use another actions localsheet - venkatbatchu - 08-05-2010
Hi,
Yes,
First Way of Doing: you could fetch the required local sheet data at required place by using Datatable.Value("Parameter ID","Sheet ID") here u could mention required local sheet as sheet id but the issue here is handling the data in a iteration manner would be some what difficult, As per my knowldge handling the data in interation manner option was available in QTP9.2 and it is not available in QTP 10. So it is always suggestable data handling from Global sheet and u could import it at required place
Second Way of Doing: U could use excel objects to handle the data at required places.. Which can be done using vb script.
Please correct me if i am wrong.
Venkat.Batchu