Friday 15 March 2013

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.

No comments:

Post a Comment

Please Leave your reply. We value your feedback and inputs

Best QTP Books

Everything About QTP

Hello Friends,
You can find QTP study material, Multiple choice questions (mcq), QTP question bank, QTP question papers, QTP notes, QTP questionnaire, scenario based QTP interview questions, QTP tutorial and QTP training on this site.

If you are a fresher or experienced QTP professional with (1/2/3/4) years of experience, this blog is just for you.