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 |
hi radhaka plz tell me clearly to handle the earrors with out isng recovery scnerio this is sreenivas from delhi
how we can do web browser using parametarisation in QTP ?
I have a tool for automation testing (eg:qtp).I have two functionality(A & B) to test.A is tested once in a year. B is tested everyday. At present i have the money and resource availability to automate only one functionality.Which one will u suggest and why?
we have one text box and one list box(list box appear in same page or another page) what ever the text enter in text box that must be displyed in list box as first one. for example if we enter 10 in text box that is the 1st item in list box . after that we enter 11 then 11 is the 1st item and 10 is 2nd item. the maximum limit of list box is 10 items. if we enter 11th item the 10th item is deleted and llth one is add as 1st one and 9th one goes to 10th position part2:maore than the answer for this question i want the the reason why testers go for this kind of risk.what is the use of we testers having these kind of attempts.is that not the problem with the developer .pls answer .real time users of tools.in which way these solutions help to test with r without affecting the developed souce code.
can u tell me the the cost of automation tool QTP ?
How you calling actions in qtp?
What is Virtual object wizard in QTP?
who QTP recognizes the object stored in object repository?
any body can you help me what is the script to automate an comand promt
Hi, I will provide perticular age,it needs to enter date in text box (MM/DD/YYYY) compare to system date. or already exist data in the text box.
how to parameterizing values from an excel sheet in Quick test professional?
What is the difference between Recover Scenario(screen) and on Error Resume Next(code)