IN EXCEL SHEET OF qtp SUPPOSE I ENTERED 10 NUMBERS RANDOMLY
I HAVE TO GET TOTAL OF TEN NUMBERS IN THE 11 COLUMN USING qtp
GIVE CODE TO IT USING qtp
Answers were Sorted based on User's Feedback
Answer / sudha sharma
Pre Condition : Enter 10 randon numbers in the datatable of
QTP. Write down the following code :
For i=1 to 10
datatable.SetCurrentRow(i)
total=cint(datatable.Value(1,1))+total
Next
datatable.SetCurrentRow(i)
datatable.value(1,1)=total
The total of 10 random numbers get posted in the run time
data table. You can view it through automation -> results -
> run time data table.
This is for QTP data table. If the data is in the excel
sheet then you have import the data.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / laxmi
datatable.ImportSheet "C:\Documents and
Settings\Administrator\Desktop\excel.xls",1,Global
then go to test->settings->run->check run one iteration
radio button
or i= datatable.ImportSheet "C:\Documents and
Settings\Administrator\Desktop\excel.xls",1,Global
for i=1
//body
next
| Is This Answer Correct ? | 2 Yes | 2 No |
how can we do the frame work in qtp
Could you please any one give code for the following ? Scenario : Suppose a excel file contains 10 records and earch have 5 fields. how can i input this excel file for datadrive wizard ? Please explain
difference between GetRoProperry and GetToProperty.and where we've to use exactly those properties
In a page i have N number of links at a time i would like to open those links by using QTP?how to do that?
what is the use of automation frame work ??(QTP)
Hi any body can tell me the in detaled information about Description.Create() thanks in advance
Hi, I am trying to automate the web application for generating Reports.I am facing issue with IE while running the script. After 4 report IE crashes.I am using QTP 9.5 with IE version 7. Can anubody give me solution for this issue. Thanks in advance-Jyotsna
QTP script is not working on other's machine..
Can we install QTP on remote server and access it as a web application on other system (client place)? If so please let me know. Thanks in advance, Ravi
Hi All, How to Compare two strings character by character in QTP
in login module login button chage regularly(means login button change to submit button).What is the code for it.
How to export data present in Datatable to an ".xls" file?