How do you data drive an external spreadsheet?
Answer / 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 |
Hello friends can anybody tell me about the architecture of QTP with diagram of it.this architecture is same for any domain like ERP/Banking/CRM/Healthcare or it's different then please tell me.thanks
Could any one tell me "How can i recognize my cursor position using QTP 9.2" Give me a scripts for this
Diff b/w WEB TESTING AND Client server testing?
how to do the batch testing in test director using manual testing procedure?
suppose the given string str = {"vamsikrishna%%&%*&**"} count the no of vowels and special characters are repeated
write a qtp code to display all the items in the fly from combo box or list box
I have thousands of links are there, i want check each and every funtionality of link by using descriptive programme, retrive link name from excelsheet then operate in application. Please anybody send me model script
What is the difference between property and method?
How do you delete unwanted results in qtp?
how i can delete the excel process for the task manager using QTP
GET WHETHER THE GIVE NUMBER VALID OR NOT IN BETWEEN THE GIVEN RANGE?IN VB SCRIPT(QTP)
What is the condition or scenario that leads the use of object spy in qtp? (while recording we can get all the properties) then wat leads to use this?