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

Answers were Sorted based on User's Feedback



Hi , I am new to VBscripting, My requirment is to write a vbscript to read a row (which has coloum..

Answer / 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

Hi , I am new to VBscripting, My requirment is to write a vbscript to read a row (which has coloum..

Answer / pinki

Try this may work.
‘Invoke the your application, open the required page
Set objExcel = CreateObject("Excel.Application") '
Creates the Instance of Excel
objExcel.Workbooks.open “ Give the excel sheet
path" 'Opents the excel sheet from given location
objExcel.Visible = False
'***********Assigning the values to the variables
X = objExcel.ActiveSheet.UsedRange.Rows.count
For j = 1 to X
Desc = objExcel.ActiveSheet.Cells(j,1)
Code = objExcel.ActiveSheet.Cells(j,2)
Date = objExcel.ActiveSheet.Cells(j,2)
Hours = objExcel.ActiveSheet.Cells(j,2)
‘*********** Assign the values to Application variables
Browser().Page().WebEdit().Set Desc



‘ click on sumbit
objExcel.Workbooks.close

Is This Answer Correct ?    3 Yes 0 No

Post New Answer

More QTP Interview Questions

distinguish between old version and new version QTP features.

0 Answers   CTA,


Which recording modes need more memory?

0 Answers  


How would you parameterize the text field "Country" and the same "country" when it appears as combo field on other page with text field city and same with City combo field?

1 Answers   Adobe, Patni,


How to make Non reusable actions into reusable action? is that feature available in QTP

2 Answers   Ordain Solutions,


i have qtp 9.5 ver software.but i don't know the license key. if anyone have license key please send it to my personal mail id(munir.reddy@yahoo.com

2 Answers  


How do function returns a value?How can we pass one function value to other function as input

3 Answers  


What is the QTP test frame work?

3 Answers   IBM,


Iam doing automation in Oracle App's using QTP? In App's because of some functional setup, keep on changing my script flow. for this how can i use the recovery sceanrio?? Please help me?

1 Answers  


I recorded a Web based Application running on JAVA and when I went to play them back a week later they didn't run. I noticed that the Browser was putting in a (Underscore and a Number) for each line so i re-recorded and noticed the Underscore line wasn't the same as what i recorded last week so any script I record today will not work next week because the browser settings or how QTP recognizes it keeps changing. This is the new line Browser("Bureau of Labor Statistics_4").Page("Bureau of Labor Statistics").JavaApplet("SurveyApplet").JavaList ("Select an Area").Select "U.S. city average" This is the old line 'Browser("Bureau of Labor Statistics_3").Page("Bureau of Labor Statistics").JavaApplet("SurveyApplet").JavaList ("Select an Area").Select "U.S. city average" Notice the Burearu of Labor Statistics_3 adn Burearu of Labor Statistics_4. Why does it change and how do I prevent it from changing.

5 Answers  


Diff b/n image n bitmap checkpoints?

2 Answers   iGate,


What is a data driven test in qtp?

0 Answers  


How many types of recording modes in qtp? Which will be used when?

0 Answers  


Categories