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.



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

Answer / sreeprasad

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 ?    2 Yes 0 No

Post New Answer

More QTP Interview Questions

does qtp runs on internet explorer 7.0

5 Answers   BeBo Technologies,


Can we set a timeout for the msgbox.I want the msgbox to disappear after 2 seconds during the script execution without clicking on the OK button manually.

6 Answers  


wt is the xtension of the QTP result view file?

4 Answers  


In QTP , Test Director combination . what is the role of Test Director? How QTP Launching QTP in T.D ? If it is Winrunner possible. but QTP How it is possible?

1 Answers   IBM, TCS,


How to retrieve the data from database?

6 Answers   Wipro,


How to handle the exceptions using recovery scenario manager in QTP?

1 Answers   Crea,


what is a file system object in QTP

7 Answers  


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

0 Answers  


if numbers are always changing write a script for that

1 Answers   Nous,


What is Terminal Emulators”? Why we used in QTP.? How he works on QTP.

1 Answers  


how many test scripts we will write in qtp? very urgent. please??? Thanks in advance..

1 Answers   Mind Tree,


Waht is User interface and Integration Testing?

1 Answers  


Categories