DataTable Import or Excel Object

[Automation_learner]

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

[Ankur]

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.