How to write data to excel file in QTP

 Example - 

Below code will  write data to Excel file in QTP

                                             

 filepath  = "C:\Bugs\Report.xlsx"

 Set objExcel = CreateObject("Excel.Application")

                                                                                                                                                                                                                                                                                                                                                                                              objExcel.Visible = True

                                                                                                                                                                                                                                                 Set Wb = objExcel.Workbooks.Open(filepath)

                                                                                                                                                                                                                                                Wb.worksheets(1).Cells(1,1).Value  = "abc"  ' read value from Excel file 

This is how we can write data in excel file using QTP .



You may also like

1. QTP Questions and Answers for Experienced guys
2. Advanced QTP Questions and answers
3. Advanced QTP Tutorial

What do you think on this topic? Please provide your feedback.