Micro Focus QTP (UFT) Forums

It was very convenient for me to validate a value in a test by using the built-in object:

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?

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.