Question: how to export data to excel sheet in qtp?
Answer: Datatable object in QTP has 2 methods which help us to export datatable sheets into excel sheet. Example - Below Code will export all sheets from datatable to excel workbook. The following code uses the ExportSheet method to save the second sheet of the run-time Data Table to the mysheet. xls.