How to Import data from a ".xls" file to Data table during
Runtime.

Answer Posted / sanhosh

The following example uses the ImportSheet method to import the first sheet of the name.xls table to the name sheet in the test's run-time Data Table. 
DataTable.ImportSheet "C:
ame.xls" ,1 ,"name"




How ever in runtime data table iam unable to get the sheet pls help me.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what QTP Options do you know?

2917


Explain about the test fusion report of quicktest professional?

525


what are the limitations of smart identification in qtp 9.0

1917


What is a checkpoint? How many check points are there in qtp?

522


When Recovery scenario actually starts while testing the application?

1535






Hi Friends, How many types of Data Bases available in market... What is the diff. while using Syabase and Oracle in a Project... ? and what is the main diff. of Syabase and Oracle databases... ? Thanx in advance..

1510


How to customize qtp?

606


What is quick test pro?

584


write a script to validate the content in the web application. (do it by OR method) and (do it by Descriptive method by creating a description object..

1792


explain keyword driven framework with banking domain?

1557


Get the count of files of similar types from a folder.

967


How many types of trigger events are there in qtp?

545


I am sathish , i want to test the Application of JIL.org ,Mobile Emulator ,by using QTP10.0. I am trying to do testing on that Application , but Child Objects are not identified by the QTP. Please can any one help me

1419


Explain about datafile/verification of date file when file is not available in local system?

2218


How can I check if a environment variable exist or not?

534