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
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 |
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 |
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 |
What is Reusable component is QTP...Anybody can answer it..Thanks in advance...
How many test scripts are prapare in ur project(HeathCare Insurance).
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)
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
what is defination of regression testing?
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 ?
What is Data driven Testing Frame work.Anybody can expain it in Detail.. Pls anybody can give the answer.. Thanks in advance...
What are the Mandatory Properties of WebTable Object and Link Object in Web testing using QTP
what is diffrense between action and function
How to count the no of objects in XML file(QTP)
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?