I am new to this forum and am looking for some guide or book to help me understand on how to work with Excel Object model in QTP. Need to do some manipulation with excel files.
Like comparing the excel files and storing them at some locations and similar manipulation through QTP.
I think component Object Model(COM) has the answer have tried by importing the excel files in QTP but that does not suffices the requirement.
I don't understand the concept How to apply the concept of Object model of excel to do its programming in QTP.
Can anyone guide me in the right direction.
Would really appreciate the help.
Try using Following Code for reading from a Excel Cell 1,1
Similaryly you can write data to excel.
Public Function getAgentName()
Set objExcel = CreateObject("EXCEL.APPLICATION")
Set objWorkBook = objExcel.Workbooks.Open("D:\JayQTP\Funtions\Data.x ls")
Set objExcel = Nothing
Hope this helps.
Quality is never an accident, it is always result of intelligent efforts.