Micro Focus QTP (UFT) Forums
DataTable Import or Excel Object - Printable Version

+- 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 Others (https://www.learnqtp.com/forums/Forum-UFT-QTP-Others)
+--- Thread: DataTable Import or Excel Object (/Thread-DataTable-Import-or-Excel-Object)



DataTable Import or Excel Object - Automation_learner - 11-07-2017

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


RE: DataTable Import or Excel Object - Ankur - 11-15-2017

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.