+- Micro Focus QTP (UFT) Forums (https://www.learnqtp.com/forums)
+-- Forum: Micro Focus UFT (earlier known as QTP) (https://www.learnqtp.com/forums/Forum-Micro-Focus-UFT-earlier-known-as-QTP)
+--- Forum: UFT / QTP Beginners (https://www.learnqtp.com/forums/Forum-UFT-QTP-Beginners)
+--- Thread: Excel Object (/Thread-Excel-Object)
Excel Object - bmcdonald - 01-26-2008
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?
RE: Excel Object - Ankur - 01-27-2008
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.