How to retrive data from a data table which is in 3rd
row,4th column and place it in main script..like retrive
name,date from data table..write script for this.
Answers were Sorted based on User's Feedback
Answer / sushil
'set the current row to 2nd
DataTable.SetCurrentRow (2)
'get the value of 3rd coloumn of 1st sheet.
abc = Datatable.value(3,1)
this code is working fine, i have checked.
| Is This Answer Correct ? | 8 Yes | 2 No |
Answer / nayan
you can try this,
VAR_NAME = DataTable.GetSheet(sheetname).GetParameter
(4).ValueByRow(3)
Hope this work out ...............
| Is This Answer Correct ? | 4 Yes | 1 No |
Answer / deepika
Hi... U can try this,its working....
Set T=DataTable.GetSheet(1).GetParameter(3)
DataTable.GetRowCount
R=DataTable.GlobalSheet.SetCurrentRow(3)
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / deepika
Set T=DataTable.GetSheet(1).GetParameter(4)
'n=DataTable.GetRowCount
DataTable.GetRowCount
'For i=1 to n
R=DataTable.GlobalSheet.SetCurrentRow(3)
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / ravikumar
set datatable to 2nd row
datatable.setcurrentrow(2)
dim abc
need to get data from the sheet
abc=datatable.value(3,1)
sure thiscode will work fine
| Is This Answer Correct ? | 1 Yes | 2 No |
Answer / deepika
Hi... if it is 4th column then GetParameter(4).Try this..
Set T=DataTable.GetSheet(1).GetParameter(4)
DataTable.GetRowCount
R=DataTable.GlobalSheet.SetCurrentRow(3)
| Is This Answer Correct ? | 1 Yes | 2 No |
Hi,
Try this
Datatable.SetCurrentRow 3
val = Datatable.Value(4)
| Is This Answer Correct ? | 1 Yes | 2 No |
Answer / shweta gupta
U can try this...
datatable.Setcurrentrow(3)
a=datatable("<4th Column Name>", dtglobalsheet)
| Is This Answer Correct ? | 1 Yes | 2 No |
Answer / k.chandra sekhar
My name is k.chandra sekhar,
My phone no is 09246540049,
Hyderabad.
My mail id is ndra_143@yahoo.co.in
If any body want full explain send the mail
Any doubts call me (ONLY GIRLS)
| Is This Answer Correct ? | 2 Yes | 4 No |
Answer / k.chandra sekhar
a) That is the data table (column, sheet)
b) If want script then start record and retrieve the
data table form 3rd row and 4th common then stop the
recording the you get the script that is the scripts
My name is k.chandra sekhar,
My phone no is 09246540049,
Hyderabad.
My mail id is ndra_143@yahoo.co.in
If any body want full explain send the mail
| Is This Answer Correct ? | 2 Yes | 7 No |
How to find operating system information using the qtp script?
str="ramanareddy12345@gmail.com"to count alphabets,numarics and special charcters pls any one knows send to answer
They asked by using qtp recording writing scripting
what is the code in QTP to take screen shot?
How to handle the exceptions using recovery secnario manager in quicktest professional (qtp)?
suppose i have one datatable in my datatable in 2 nd row 3rd column one link is ther i need to validate that link how do u do this?(wipro)
if devloper change only button names in present build then script will execute or not , why? Only gui changed.......
what is main diff of qtp8.2 and qtp9.0?
how to create flat file datasubmission in qtp
How to add object to object repository in qtp9.0 Suppose for brower yahoo home page
how to retrieve the value from data table to the script and using the value to be displayed in message box. an also retrieve the value of the output value during runtime to the script or separating and using that value in the script.
I have a tool bar where 5 different buttons are placed, but these buttons are not traceable hence i have created a virtual object on save button of this toolbar. Now pls tell me how to use this virtual object while write script.