Interested to Buy Any Domain ? << Click Here >> for more details...
If i entered 2 columns and 4 rows inputs in DDT Like Mango
fruit, Banana Fruit, Brinjal Veget, Carrot Veget.. . My Q
is How to get the 2nd column value for corresponding 1
column input in 3rd row ie, ( i need to get "veget" in
messge box @ run time
- 5 Answers
- 9096 Views
- CTS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / satya
strCnt=DataTable.getRowsCount
For i=1 to strCnt
datatable.SetCurrentRow(i)
x=datatable.Value("A")
datatable("c")=x
Next
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / ratna
datatable.setcurrentrow(3)
x=datatable.value(2,1)
'datatable.value(2,1) where 2 is column name and 1 is sheet
no. ie., 1 is for global sheet
msgbox x
'output is veget
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / saff
i= inputbox "enter ur string" # say brinjal
r=datatable.getrowcount #get row count
for i=1 to r #loop till the end of the row
datatable.setcurrentrow(i)
aa=datatable.(a ,dtglobalsheet) # column 1 value into aa
if instr(aa,i,1)=1 #compare the strings
bb=datatable(b,dtglobalsheet)
msgbox bb
exit
else
i=i+1
next
| Is This Answer Correct ? | 0 Yes | 1 No |
i have an external excel datasheet where it only contains 3 rows. after qtp executed the code to import the datasheet, the datatable getrowcount method now gives me a different value, lets say 60,000+ instead of only 3. i did not have any values starting from row 4 of my excel file. why is this happening? this also results to the qtp report to load for a very long time.
Why to use descriptive programming?
write a script for get the following result: username password frm the string1="A=username" string2="B=password"
how to export the result to notepad....for example i want to enter the user name and pass word and clicking on login button ......once you click on login button the corresponding page will open ...in that page you having one list box ...here you can get either success or failure ........friends here i want export the message what ever i got either success or failure .....how to export the result to note pad
How will you enchance the script?
Hi, I am learning QTP. can someone please tell me a site from where i can learn QTP scripting Thanks in advance
write a script to validate the content in the web application. (do it by OR method) and (do it by Descriptive method by creating a description object..
what is the main process in QTP?
In QTP, while launching qtp application from startup.. we find Advanced Keyword-Driven Testing caption.. wht is that...Anybody can pls explain it. Thanks in Advance
What is the difference between link and hyperlink?
How does qtp identify the object in the application?
What is keyword view and Expert view in QTP?
WinRunner 
