Micro Focus QTP (UFT) Forums

Full Version: DataTable Import or Excel Object
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Hi,

Is it better to use Datatable Import function to read the data from an excel or use Excel object to retrieve the data?

Which one is more efficient and why?

Please answer and appreciate your help!

Thanks,
AL
Good question.

With the former you can use all usual DataTable methods exposed by QTP/UFT, with the latter you use AOM.

As for performance, you can test it out with a simple data and let us know your findings.