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 export data present in Datatable to an ".xls"

file?

Answers were Sorted based on User's Feedback



How to export data present in Datatable to an ".xls" file?..

Answer / sailaja

a=Datatable.Value("path")
msgbox a

Is This Answer Correct ?    1 Yes 5 No

How to export data present in Datatable to an ".xls" file?..

Answer / sreeprasad

DataTable.Export("Path of the sheet")

or DataTable.ExportSheet("Path of the sheet",Index of the

runtime datatable u want to export")

Is This Answer Correct ?    2 Yes 8 No

How to export data present in Datatable to an ".xls" file?..

Answer / chinna

Hello,

Export data into Excel Sheet we will follow 2 methods.

1. Datatable.Export("Path of the sheet")
2. Datatable.Exportsheet "Path of the sheet",Source sheet id

Is This Answer Correct ?    2 Yes 8 No

Post New Answer

More QTP Interview Questions

How u execute test cases in manual testing?

2 Answers   Accenture, Infosys,


what is verification & validation?

2 Answers   Accenture,


Hi Friends, Can you please answer these questions of QTP Certification? 1.) What are bitmap checkpoints sensitive to? A. Image size and object type B. Object type and image type C. Screen resolution and object type D. Screen resolution and image size 2.)What are the phases in the QuickTest workflow? A. Plan, Record, Enhance, Run B. Prepare, Record, Verify, Run C. Plan, Create, Verify & Enhance D. Prepare, Create, Verify & Enhance, Integrate 3.) What are the two most commonly used ADO objects? A. Fields B. Execute C. Connection, RecordSet D. Open, ConnectionString 4.)What options are available to filter objects in the Target Object Repository pane when merging object repositories? A. Show all objects or Show only objects with conflicting object types B. Show all objects or Show only objects with conflicting descriptions C. Show only objects with conflicting logical names or Show only objects with conflicting object types D. Show only objects with conflicting logical names or Show only objects with conflicting descriptions 5.)Which of the following is an example of a missing resource? A. An object B. Run Results C. A Regular Action D. An External Action 6.)What method is used to retrieve the number of columns in the query results? A. Fields.Count B. Fields.Item(EOF) C. Fields.Count(BOF) D. Fields.Count.Value 7.)In VB Script functions, which one is false among the following a. Variables must be declared before use b. Variables may not be declared before use c. Variables may be declared without data types None

2 Answers  


Why do you choose only QTP for your project automation among remaining tools like Rational robot and silk test?

2 Answers   CTS,


hi all i have qtp 9.0, Active screen is not working means after recording script snap shots not displayed in Active screen window. i have all ready check all setting means Tool...>option...>Active screen...>Default Level button is disabled. Is there other setting is remain to set Pls help i m new for qtp

1 Answers  


Where you are storing your script?

0 Answers  


Is virtual object supported in low level recording mode?

0 Answers  


How you know that a test case is a regression test case

1 Answers  


breef description of batch testing ?

0 Answers   Wipro,


hi what is the use of "dim" in automation objective model or any where what is the use of "dim" plz tell me

3 Answers  


What is the difference between a Function and Action in QTP?

0 Answers   Wells Fargo,


What is the use of Testing framework in Automated testing..what are different kinds of Testing frameworks available in Automated testing...

1 Answers   IBM,


Categories