Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

Call to copy of an action and call to existing action… i know the diff but in real project how to use..? i want live scenario.pls help me..

1795


What is the differences between image check point and bit map check point?

1088


What is the difference between the keyword view and expert view?

968


How to start recording using quicktest professional (qtp)?

1106


wht type of User defined functions or Java Releated functions do we write in VB scripting

2246


what is keyword driven testing in qtp?n how is it useful?

1929


How to import a test case present in ".xls" file to TD under a Test set?

1227


When to use descriptive programming?

1126


What are private functions in QTP? How they can be called from the function library?

1044


How many types of recording facility are available in quicktest professional (qtp)?

1067


how do i know how to use tools

2002


Can we create a qtp test from qc?

1034


What is the difference between shared and local object repository?

1120


Why do we use breakpoints in QTP?

1063


Can any one say what exact diff between test->parameters, action properties-> parameters. after defining the parameters in test->settings, how can we access those parameters.(i know how to use action prop parameters)

2118