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


Please Help Members By Posting Answers For Below Questions

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

1437


What is the use of Debug Viewer?

1490


What is parameter in qtp?

680


How may types of defects identify application or your currently working application?pls give me answer..

1517


What is difference between shared and local object repository?

589






what is object and child object.. explain ..if possible give some example for better understanding ..

1531


How do you synchronization point through DP?

603


What is quick test pro?

592


Explain hybrid framework with advantages and disadvantages?

543


What is data driver in qtp?

578


Write the code for,In the page screen we have total 10 Links,out of these I have to click 9th link

869


Hello friends..... On which areas of an application we can not test with QTP

1559


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

1538


Which is the best QTP training institute in Delhi/NCR region and what is the approximate fee for QTP course (Basics and Advanced)

1383


How to use descriptive programming?

616