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 |
can u write Script to do Data Driven Testing throuh Externel & internel XL Sheet
what is framework in QTP? any one give me answer
In QTP whether is it possible to call a function from one action to another action?
Can we directly automate testscripts accrdoing to requirements
2 Answers CitiGroup, Novartis,
How can i use Ordinal identifiers and Smart identification methods suppose i want to know the index no of check box
any body can you help me what is the script to automate an comand promt
How i can use Regular expression in QTP?give detailed steps for it.
What is the syntax to call one script from another?
If a button named "CLICK" is recorded in low level recording mode , what will be the values stored for "name" property of that button in object repository ?
Plz send one Tracebilitymatrix example? Anybody working on Realtime QTP Plz give contact deatils?
What is quicktest professional?
How many types of Actions are there in QTP?