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

Answer Posted / deeps

Hi,
DataTable.Import("path of the file")

DataTable.ImportSheet("filepath","sheetsource","sheetDest")

Sheetsource:index or name of the sheet in the file which u
want to import. index begins vth 1.

SheetDest: index or name of the sheet in the datatable
which u want to replace vth Sheetsource.Index begins vth 1.

ex:
Datatable.importsheet("c:\name.xls",1,"name")

Is This Answer Correct ?    14 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

HOW AUTOMATE TEST SCRIPT ? what time it will do? after gneration of basic script or Any , Plz explain detailed?

1718


When and why to use descriptive programming?

609


how do i know how to use tools

1455


I am in .Net development for past 3.5 years and want to enter in to automated testing and learn QTP. For this I need some good tutorial for beginners. I will be really greatful if any one has and they can send it to me on this address- ruchidureja@gmail.com

1481


how to acess a test in RSA?

1671






What is the use of text output value in quicktest professional?

512


For example you are checking bit map check point before coming to the results. How can you say it is passed? Or failed? Anyways?

617


How you debug your script?

571


Does Low-level recording capture mouse movements?

584


Why do we use "Text checkpoint" If we can make use of it in "standard checkpoint" ?

1486


what type of framework u r using in ur organization

1652


what is the difference between modular framework & datadriven framework

1597


Shall we add Local Repository to shared object repository,if yes,how we add

5695


How many types of status are there?

589


What is a reusable action?

576