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 |
To which environments does QTP supports ?
If requirments changed then how we can teach the QTP this is the new requirment
How to associate shared object repository to test in qtp?
Hi, I am using 2 excel sheet.First excel sheet works fine with the script, if it opens the 2nd excel sheet,it works fine,but after finish all the rows it is giving the following error in the following line. InValid Procedure call or argument Line (178): "Browser("name:="&result,"application version:=internet explorer 7").Page ("title:=bgt.*", "index:=0").WebList ("name:=SearchType","html id:=Select1","location:=0").Select SearchType1". I have seen a web article says that,If we use any vbscript friendly name it may gives the above error-Invalid procedure call or argument not sure,Am I using any VBScript frienlyName? in the above line? [but the same line is perfecly working for first Excel ] It is little urgent. Any Help Thanks you
What is the extension of script and object repository files?
What is the difference between Image Checkpoint and Bitmap Checkpoint?
how could i download qtp in which i get add-in support for 'oracle' is there any way to get it? i finding but not getting pls help me out :)
Take a situation when you are working with QTP, suddenly system has crashed.so you again start the system. My questyion is how can QTP directly opened when the system desktop appears.
How to handle the exceptions using recovery scenario manager in QTP?
will QTP 9.2 run successfully on Linux(gui) operating system
Hi can anyone pls suggest how to fetch username(system login name)and system name in to qtp.I am not using TD or QC.Thx
Please can you give where can we get good QTP Training at Hi-Tech city Hyderabad?