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 to parameterize a text field and the same field as combo field on next page. Means inserting values in Text field will appear in the combo field. for example country name, state name. Kindly reply it is urgent !!!

1 Answers   Adobe,


please tell me how to identify the index of the link in the web table .links are not constant.example i want to click the link in the inbox ,search the item and click the partcular mail.(mail links count is not constant)

1 Answers   IBM,


how to write script in qtp(vbscript)..i mean with out application deployed..and how to call script1 into script2?

2 Answers  


I'm having a problem to get the status(pass or fail) during runtime for every iteration ran, and must get the results stored to an excel sheet if possible.

1 Answers   FAI,


Can anyone tell me what is the equivalant method to be used in QTP for "web_obj_get_text" used in winrunner. My winrunner code is below. set_window("Confirm Add Subscriber"); rc = web_obj_get_text("Add subscriber:","#8","#1",orderID,"The order number is","\.",1); basically I need to retrieved the "orderID " from a string present in 8th row & 1st col of table "Add subscriber"

1 Answers  


Please mail me the license key of QTP 9.5 t v.sadangi@gmail.com ????? thx

0 Answers  


.qfl extension for which file? where vl use it

1 Answers   iFlex,


what is the Command used to start the QTp from Run.(start-> Run)

7 Answers   GE,


Please any on explain usage of "on error resume next","On error goto 0" with sample code....Thankyou......... when a tester is asked to execute 100 scripts in a short time..(the server will be down in another 10 min)..how he has to run those scripts?

2 Answers   Datamatics,


Wt is the difference between Business Component and scripted component?

1 Answers   BSL,


Synchronization methods?

8 Answers   Ordain Solutions,


What is BPT?

2 Answers   Allied Group,


Categories