QTP Data Table Having 10 records with 10 to 15 fields(lets
say).now i want to get alternative records from datatable.pls
can any one answer it?

Answers were Sorted based on User's Feedback



QTP Data Table Having 10 records with 10 to 15 fields(lets say).now i want to get alternative reco..

Answer / veeranki naveen goud

set dtsheet1 = datatable.GetSheet(1)
rcount = dtsheet1.GetRowCount
ccount = dtsheet1.GetParameterCount
For i = 1 to rcount step 2
dtsheet1.SetCurrentRow i
For j =1 to ccount
n = dtsheet1.GetParameter(j).ValueByRow
(i)
msgbox n
Next
Next

Is This Answer Correct ?    13 Yes 0 No

QTP Data Table Having 10 records with 10 to 15 fields(lets say).now i want to get alternative reco..

Answer / veeranki naveen goud

set dtsheet1 = datatable.GetSheet(1)
rcount = dtsheet1.GetRowCount
ccount = dtsheet1.GetParameterCount
For i = 1 to rcount step 2
dtsheet1.SetCurrentRow i
For j = 1 to ccount
n = dtsheet1.GetParameter(j).ValueByRow(i)
msgbox n
Next
Next




Regards,
Veeranki Naveen,
Noida.

Is This Answer Correct ?    4 Yes 1 No

QTP Data Table Having 10 records with 10 to 15 fields(lets say).now i want to get alternative reco..

Answer / pushkar1206

datatable.AddSheet"pushkar"
datatable.ImportSheet "C:UserspushkarDesktopBook1.xls","Sheet1","pushkar"
rw=datatable.GetSheet("pushkar").GetRowCount
clm=datatable.GetSheet("pushkar").GetParameterCount
For i=1 to rw step 2
For j=1 to clm
a=datatable.GetSheet("pushkar").GetParameter(j).valuebyrow(i)
msgbox a
Next
Next

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More QTP Interview Questions

What is Reusable component is QTP...Anybody can answer it..Thanks in advance...

8 Answers   Siemens,


How many test scripts are prapare in ur project(HeathCare Insurance).

1 Answers   Virtusa,


The structure of keyword driven frame work is like a folder structure the different sub folder are 1-functional libray folder 2-object repository folder 3- database folder 4-appliction1.xls 5-initalzation vbs file 6-sequence file 7-driver script 8-test case list file My question is whether these are in a local server machine or in our pc.((whether It like Vss). can u give example of driver script(code)

0 Answers   TCS,


suppose our project is developed using java technologies.after complition of the coding developer relesed a build to the testing team.so, what is the process means how we open that documents?what are that documents?plz give reply its urgent

2 Answers  


what is defination of regression testing?

3 Answers  






How can we merge two repositories? Can we merge two differnt rep. I mean 1is peraction and other shared

4 Answers   Tavant Technologies,


i am testing an online shopping application.I CLICK on a link "ADD TO CART" of that application a "new page" is open and then click on any object of that "new page". after that when i run this SCRIPT then on this "new page" QTP always shows error of "OBJECT NOT FOUND". How i solve this problem ?

4 Answers  


What is Data driven Testing Frame work.Anybody can expain it in Detail.. Pls anybody can give the answer.. Thanks in advance...

1 Answers   Navis,


What are the Mandatory Properties of WebTable Object and Link Object in Web testing using QTP

2 Answers   iLink,


what is diffrense between action and function

4 Answers   IBM,


How to count the no of objects in XML file(QTP)

1 Answers   IBM,


Hi I am new to QTP. we are planning to implement automation for the application. I am trying to execute the following script: Set ExcelObj=CreateObject ("Excel.Application") ExcelObj.WorkBooks.Add Set NewSheet=ExcelObj.Sheets.Item(1) NewSheet.Name="Order" ExcelObj.Cells(1, 1).Value = "Name" ExcelObj.Cells(1, 2).Value = "Ordernum" ExcelObj.Cells(2, 1).Value = "nam" ExcelObj.Cells(2, 2).Value = "21" ExcelObj.ActiveWorkbook.SaveAs "c:\test1.xls" ExcelObj.Quit Set ExcelObj = Nothing in the above script for the line(ExcelObj.Cells(2, 2).Value = "21") it is inserting the value 21 successfully.this is fine But if i want to insert a variable instead of the constant value then what should be the modification in the script. For example: If user retrives a value throug "GetRoProperty" and wants to insert the value into then how the script changes?

1 Answers  


Categories