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 |
Explain the check points in QTP?
how to get the data from a winedit box in vb scripting and store it in a variable if data contains "_"(i.e data is TEST_1)
What is wrong in my code?
Find the 'String' from excel sheet and save to another sheet.But we don't know the string column number and row number?
I am facing an issue of object identification with the dropdown element of DHTML grid. When I tried to recognize these different dropdown objects, QTP identifies only one object for all the dropdowns. Hence, selection of different data from different dropdowns list is an issue. To overcome this problem, i have used Descriptive Programming technique by creating different object descriptions which have all the other properties same but differ only in one property i.e. ‘X’ location of the element on the screen. Hence, i have created distinct object descriptions that would allow us to select values in different dropdowns. The code is given below. But still I am unable to identify distinct dropdown objects. ‘Object Description for Dropdown Cell Status Set objCellStatus = Description.Create objCellStatus("micclass").value = "WebList" objCellStatus("name").value = "select" objCellStatus("x").value = 219 ------ ‘X’ Axis value for cell status drop down ‘Object Description for Dropdown Sub Segment Set objSubSegment = Description.Create objSubSegment("micclass").value = "WebList" objSubSegment("name").value = "select" objSubSegment("x").value = "319" ------ ‘X’ Axis value for sub segment drop down Please help... This is specific to DTML grid(Drop down object)
Which object repository we use in real time and can we merge 2 object repostiory and how?
i am trying to capture the URL from the open browser and store it. pls give me solution how we can do this in QTP. thanks
What are the different recording modes?
What are the technologies supported by qtp?
Hai Guys, can anybody show me how to write automaed test cases using VB scprit(examples)...i had an interviw soon...please guyz send as quickly as possible
what is framework? which frame work u follow for writting script?
How to create scenario selector