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

What is the basic concept of qtp?

0 Answers  


How to call actions in QTP?

2 Answers   Wipro,


How to add verification steps to tests?

1 Answers  


How to do the scripting. Is there any inbuilt functions in qtp as in qtp-s. What's the difference between them? How to handle script issues?

0 Answers  


Our company is having a windows client server application developed in vb.net. so there is a treeview and i am not in a position to record the click events in QTP. so kindly help. Vivek

0 Answers  






i am a begnner so am learning Error handling :tried using Recovery manager didnt work i want to be able to handle errors , e.g. if while running the test the folwoing does not show up then how can i use the If then else and goto next step in the test, as in many scenarios it does not show up Browser("The Shopping Channel -").Page("The Shopping Channel -_8").Image("easy pay").Click

0 Answers   Rogers,


How can we get a textcheckpoint in QTP9.1?

2 Answers   EmTechPro,


Is QTP supports Unix. If yes, then how the test automation is done?

0 Answers   iFlex,


I heard that in Hyderabad Ameerpet is renowned for its training institutes it has , but from my own experience I can only say that this institutes have become money making machines losing their cognitive ability and ethics , can anybody tell me is there a good ins. in hyderabad for testing tools.?

2 Answers  


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

0 Answers   TCS,


how to automate standalone infopath forms using QTP? (it is not a dotnet or a web form)

1 Answers   ABC,


what are recovery management techiniques?

1 Answers  


Categories