Interested to Buy Any Domain ? << Click Here >> for more details...
how to retrieve data from the data table (from a particular
cell)
- 7 Answers
- 32225 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / uday kumar_anem
First goto the the row and then retrieve the value from the
required cell.
datatable.SetCurrentRow(rowid)
datatable.Value(columnId,SheetId)
Ex:
datatable.SetCurrentRow(3)
val=datatable.Value(4,1)
| Is This Answer Correct ? | 23 Yes | 3 No |
Answer / milan
Uday your answer is right but if you have 3 values in
datatable then you will get the same value 3 times....
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / nitin sharma
Function isparameterexist(sheetname,parametername)
on error resume next
if isparameterexist=true
err.clear
set param=datatable.getparameter("parametername").getsheet("sheetname")
if err.number<>0 then
isparameterexist=false
End IF
End Function
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / chaitanya chivukula
Print getvalueByrow("UserName","36")
Function getvalueByrow(colName,rownum)
DataTable.Get("SheetName").GetParameter(colName).RowByValue(rownum)
End Function
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / dibyendu hembram
from my point of view there is no such function to retreive
data from a particular cell. what i think to retreive a
data from a particular cell we have to first create excel
sheet object and then by creating excel object we can use
the excel sheet function to access the particular cell
| Is This Answer Correct ? | 7 Yes | 9 No |
Hi am New to Automation Testing , any one can you help me what are the basic questiion are asked an interview?
How i can test the background color of the records displayed in a Table. Eg i have a .net desktop application and there is a Table(swftable) with records displayed in the grids. i have to validate whether the 1st record is displayed in white background color and 2nd record in light blue background color...But the constraints is that once user click on the first record...the background color changes to grey.......Plze let me now how to validate this with QTP 9.2.
How can you handle exceptions in qtp?
What the genaric function to connect Sql Server using Sql Server Authentication and Windows Authentication
How we can add actions in the test using QTP?
Where u will use output checkpoint in QTP?
How to Test Dynamic links ?
how can i pass a "cript"as a parameter in to a function
How to get the particular property value?
In qtp, explain what is keyword driven automation framework?
explian about the qtp frame work? where u can use it in your project?
Hi all. Could anyone tell me the difference between an Action and a Function in QTP. Thanks in advance and Merry Christmas.
WinRunner 
