How to Import data from a ".xls" file to Data table during
Runtime.
Answer Posted / chinna
Hi,
Datatable.Importsheet("Path of the sheet",Source sheetid,
Destination sheetid)
Ex.Datatable.importsheet("C:\Book1.xls",1,1)
z=datatable.getrowcount
For i = 1 to z
datatable.setcurrentrow(i)
A=datatable.value(1,1)
b=datatable.value(2,1)
c=a+b
datatable(3,1)=c
Next
msgbox c
Is This Answer Correct ? | 10 Yes | 1 No |
Post New Answer View All Answers
1.explain end to end process of qc,2.how many tabs are in qc9.0,qc10.0 3.what is review, how many reviews are following in aproject 4.how will you get the requirements 5.why do we choose testing 6.how to export tc's and requirements to qc through add-ins
What is the use of Debug Viewer?
What is parameter in qtp?
How may types of defects identify application or your currently working application?pls give me answer..
What is difference between shared and local object repository?
what is object and child object.. explain ..if possible give some example for better understanding ..
How do you synchronization point through DP?
What is quick test pro?
Explain hybrid framework with advantages and disadvantages?
What is data driver in qtp?
Write the code for,In the page screen we have total 10 Links,out of these I have to click 9th link
Hello friends..... On which areas of an application we can not test with QTP
How can we extract data like "Details","Result","Time" from the 'Run Error' result generated in QTP after run time errors are generated during a run & import the details etc...into excel sheet
Which is the best QTP training institute in Delhi/NCR region and what is the approximate fee for QTP course (Basics and Advanced)
How to use descriptive programming?