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

str="QTP AUTOMATION TESTING" here how many T are there in the str finally i want to display the T

10 Answers   HCL,


when we enter url,one page should open.write a vb script ,that page is open or not

2 Answers   Blue Chip India, Persistent,


QTP9.1 does not support to text checkpoint in Windows application? Is this correct? If this is correct, what is alternative for Text checkpoint?

2 Answers  


hi gavasker i want how to merg OR's in QTP 8.2 by QTP Plus

1 Answers  


What are the enhancements u did after recording ur script?

1 Answers  






Hello Everyone, In QTP we have one option Data Driver wizard that comes in Tools -> Data Driver. so, please tell me abtout the use of Add Value and Parameterize options available in Data Driver wizard. And also the concept of value, constants, Parameterized displayed in the wizard. Please explain by giving the example. Thanks in advance, Gaytri

2 Answers  


I m new to QTP? Is it necessary to know VB for learning QTP for Automation? Can I understand QTP excellently Without practical automation?

3 Answers  


3. Anyone pls tell me as many points as possible for this question? what r the things to take into consideration before automating an application like; a). Identify whether the tool supports the appln or not. b). When there is lot of retesting and regression testing. c). ROI. d). When there is a need for running same script for multiple datas, etc. e). ---- f). --------- Pls give me more points.

1 Answers  


what type of application we can select for automation testing and what is the entry criteria for automation

1 Answers  


Iam doing automation in Oracle App's using QTP? In App's because of some functional setup, keep on changing my script flow. for this how can i use the recovery sceanrio?? Please help me?

1 Answers  


Is there any thing that we can replace recovery scenario manager in QTP.

3 Answers  


Is virtual object supported in low level recording mode?

0 Answers  


Categories