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 run-time data?
Explain how Does Run time data (Parameterization) is handled in QTP?
Hi frnds, does anybody know if there is anything called "thin point" or something in qtp? thanks in advance.
What are the things(properties, and other details) will be recorded while recording an object using normal recording?
who QTP recognizes the object stored in object repository?
Diff b/w Health care domain and Banking Domain?
What are main panes available in qtp test browser?
What is text/text area checkpoint?
hi to all, i need a code.. in flight application 1.i need to login first then i need to insert 3 new orders... 2.i have to log out 3.i have to login again with different user 4.need to insert 2 new orders 5.then need to log out 6.then again login with different user 7.3 new orders create and log out 8.but we hv to do this using data table and actions please help me
What is test object model in quicktest professional (qtp)?
I hav installed QTP8.2, im working on webapplication, while running the script giving error msg like "QTPro.exe generated errors and will be closed by windows. You will restart the program. An error log is being created". Pls anybody what is the problem, what i have to do for this? Thanks...
Is it possible to split an action? How?
PLEASE TELL ME WHEN DO YOU USE THE OBJECT SPY AT RUN TIME
How can you close the second opened browser?
If we put all properties in mandatory and assistive list of Normal Identification, Do we still need Smart?