Thursday 14 March 2013

How to read value from Excel cell in QTP



 Example - 
Below code will read a value from Excel cell in QTP
                                             
 filepath  = "C:\Bugs\Report.xlsx"

 Set objExcel = CreateObject("Excel.Application")                                                                                       objExcel.Visible = True
                                                                                                                                                                     Set Wb = objExcel.Workbooks.Open(filepath)
                                                                                                                                                                     print Wb.worksheets(1).Cells(1,1).Value 

  ' read value from Excel cell 1,1
                                                                                      

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.