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 QTP recognize the object??how to add objcts into object repository??
What is the syntax to call one action in another?
What’s the basic concept of QTP?
how many types of actions r there? what r they? explain? pls give any one answer?
in QTP we test web based application at that time what script is run? is support vb script? plz tell me
How to build scripts that access data from external sources?
Does QTP supports Linux or Unix OS?.If so which scripting is preferable? Shell we do record and playback
How software automation specialist enter steps in the Expert View?
Hi, i have a string like "INDIA". I need to display this string vertically in Msgbox?
What is keyword driven Testing Framework. Anybody can explain it in details... Pls anybody can give the answer.. Thanks in advance...
what is the criteria for choosing test cases for automation? Ex: if you have some 300 test cases, then how many you choose for automation. what is criteria of selecting?
3 Answers Aricent, Delhi University, TCS,
i need to learn the descriptive programming very well so for that what to do am reading the qtp user mannual but it is not so any materials or links with examples i want please help me