Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Excel Object
#1
Solved: 11 Years, 4 Months ago
It was very convenient for me to validate a value in a test by using the built-in object:
Code:
XMLFile("xmlfile.XML").Check CheckPoint("xmlfile.XML")

I wanted to do something similar with an Excel file. Is there a plug-in or an object that will do this for me?

I have already created an action called VerifyExcelCell that I can pass all the relevant info (filename, sheet, row, column, check_value). It uses the DataTable object to load the sheet and get the value to verify. But the XMLFile object is so convenient. Isn't there a similar one for Excel?
Reply
#2
Solved: 11 Years, 4 Months ago
There is no built-in object to do the same operation in excel.

As you mentioned above, you need to use the custom defined function.
Want to fast track your QTP/UFT Learning? Join our UFT Training Course
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  How to export the output value of a webedit object to a new excel file. mounika6677 1 1,515 04-14-2019, 05:18 PM
Last Post: mounika6677
  Problem in creating excel object kriday 1 2,350 07-13-2013, 12:45 PM
Last Post: Ankur
  ActiveX component can't create object: 'Excel.application' RGummadidala 3 20,184 09-06-2012, 12:35 PM
Last Post: sandya
  Excel model object reference shiffy 2 2,987 04-10-2012, 10:08 AM
Last Post: sshukla12
  purpose of filesystem,excel,xml object creation priya999 3 3,612 02-28-2011, 03:36 PM
Last Post: basanth27

Forum Jump:


Users browsing this thread: 1 Guest(s)