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


Please Help Members By Posting Answers For Below Questions

is there any addin for remedy user application

1963


How do you handle multiple banners(at the top the page, the banner is scrolling) in a web page(Dont take the name property(regular expression))

1861


Should have experience in framework means?

1619


What are the recording modes in wave event?

1744


What is the difference between run time object and test object in QTP?

782


HI I want to know the detials of QTP certifications such as syllabus, study Materil etc. Can any provide me all these details?? my mail ID is krishnuvk@yahoo.com

1735


Whar are the challenges do we face while testing web based applications using the automation tool QTP or any??

1830


In application which areas to be automated and what kind of situation will be take? using QTP? Plz give me the clear answer

2133


In an interview, what r the general questions asked in SQL which is realted to testing ?pls give me anwser to this question?

1662


In an interview, what r the general questions asked in QTP? pls give me anwser to this question?

1616


There is an built in window application in qtp9.1,i.e.Flight4.0.i want to implement the recovery maneger on it.How can i do this?

1808


How to use reporter.report event in qtp ?

770


What are table and db checkpoints?

785


In qtp, explain what is qrs file?

783


What do you mean by checkpoints in qtp?

763