Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / santhosh
To data drive an external spreadsheet we just import that
spread sheet
In QTP,this can be done in two ways:
1) Using VB Script like datatable.ImportSheet "path of the
file",1,1
Where '1'specifies the file is for reading purpose
While another '1'specifies that the file is in ANSI Format
2) Anothe method u just right click on the Data sheet of the
QTP there u will find 'Import'option click on it and go for
the spread sheet,Now rest of the thing is same like by using
VB Script and counting the values in the data sheet and
retreiving from the Datasheet.
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
Hi, how can we check or avoid the memory leakage in QTP9.2?
How will you test a keyboard?
how to write the descriptive programming in QTP for remove the object value and substitute, with a variable then call the validation from excel
What is the framework your company is following. What is the reason. Explain why key word driven frame work is chosen.
write the vb script for call to new action in qtp?
How u will do versioning in QTP?
How can i check items sorted or not in a weblist ? Give me the script for this...
Will down time for server and content maintenance/upgrades be allowed? how much?
In the application that I'm testing is having a WYSIWIYG editor.QTP is recording editor's body as web element. I want to add some data to this web Element at run time. The problem is that I cant find a method to add contents to this web Element. Can any one come up with an answer for this. Thankx.
Is it possible to use two instances of UFT on the same machine? If not why?
What do you mean by iteration?
What are test settings and global settings?
What is difference between run time object and test object?
How do you know the location Id of an object if you know its index id?
Hi, I am using OutputCheckPoint for 2 webelements Bed:4 and Bath:2 Full,1 partial in my result page and I am storing the value in the data table. I dont need the string Bed:4,I would like to get only the no 4. How can I get it? Even though I highlight only 4,It is seleting the full value "bed 4". Same thing happend for second webelement Bath:2 Full,1 partial I need only the No 2. I used the following to split MyArray = Split(UIBathResult, " ", -1, 1) But it is giving the value My Array(0)=Bath:2full,1Partial I need the only the nos for further comparision.Any help? Thanks Uma
