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

file?

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

How to replay a script in qtp?

722


Hi! My OTP script has several bitmap checkpoints included which I check in the test results xml file. The test is for SAP 4.7. I need to save these bitmaps to files or at least export them to the html file using the export function in the test results viewer. Could you please help me with this problem? Thank you in advance! Best regards, Peter

2312


How to change the priorities of the recovery scenario properties?

686


How qtp recognizes the object?

765


By using QTP can we record any log files written by the application which is in execution?

1581






What is the use of text output value in quicktest professional (qtp)?

681


What is the syntax to call one script from another? And what can be the syntax to call one “action” in another?

784


what is command for executing files?

1593


Is virtual object supported in low level recording mode?

715


Can we access the java methods in qtp. Because my requirement is to access the swt(for eclipse an it is java code) methods in qtp is it possible?

1631


Did the scripts need lot of maintenance? If yes, why?

3407


In qtp, explain what is crypt object

704


I am getting an error "failed to open the XML checkpoint result viewer" in result window,after clicking on "View XML checkpoint results".Someone suggest me settings,if any...

1558


What test you perform mostly? Regression or retesting in your testing process?

663


If u r using library files (Instead of Check Points) , How do u do bitmap check ?

1557