Hi , I am new to VBscripting, My requirment is to write a
vbscript to read a row (which has coloumns like
Description, Code, date(DD/MM/YY), hours etc) and export
these feilds to a Website and then click on Submit
Automatically on that web page. This it should do for all
the Rows in that excel file. Any help is much appriciated
Thanks
Shalini
Answer Posted / samrat
DataTable.AddSheet "qtpsht"
DataTable.ImportSheet path,"srcsheet","qtpsht"
rowcnt=DataTable.GetSheet("qtpsht").GetRowCount
For i=1 to rowcnt
datatable.Getsheet("qtpsht").Setcurrentrow(i)
'Invoke ur application
'get the test data and store in variables
StrDescription=DataTable.Value("Description",qtpsht")
StrCode=DataTable.Value("Code",qtpsht")
Strdate=DataTable.Value("date",qtpsht")
'apply the above variables into ur application and then
submit
'close ur application
Next
hope this meet ur rqmt..
crct me if iam wrong...
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What is method name to compare two XML files.
Explain in brief about the quicktest professional automation object model?
Did QTP prove efficient for your project? Yes or No, explain?
Explain the concept of object repository and how qtp recognises objects?
What are the types of object repositories? Which one is you are using?
How to associate function library at a run time?
Explain advantages and disadvantages kdf?
Without using gui map editor we can recognize the application in winrunner ?
Can the user toggle between using Local OR and shared OR for the same action?
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.
What are the automation metrice in your project?
How to find the difference between 2 dates in qtp?
before launching qtp, we need to close all the open browsers u dont know what are all the browsers either it might be ie,mozilla etc and u dont know how many brosers are open.... u need to close all these before launching qtp.. can anyone plz temme d solution...
Is QTP Supports SWT applications? If yes, can you write a sample script for opening a new package in eclipse.
How to create runtime property for an object?