How to export data present in Datatable to an ".xls"
file?
Answers were Sorted based on User's Feedback
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 |
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 |
How u execute test cases in manual testing?
what is verification & validation?
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
Why do you choose only QTP for your project automation among remaining tools like Rational robot and silk test?
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
Where you are storing your script?
Is virtual object supported in low level recording mode?
How you know that a test case is a regression test case
breef description of batch testing ?
hi what is the use of "dim" in automation objective model or any where what is the use of "dim" plz tell me
What is the difference between a Function and Action in QTP?
What is the use of Testing framework in Automated testing..what are different kinds of Testing frameworks available in Automated testing...