Datatable vs excel.application

[mizan rahman]

Can any body Please explain which one is better to use: import Excel file in datatable or create object of Excel.Application.
Please explain, Thanks.

[Vivek]

Mizan,

Importing excel file in datatable will be more flexible way to handle data in QTP. However I'll recommend to use excel as database.

regards,

Vivek

[uma mahesh]

create object of Excel.Application is the best method as per my experiance.

Regards

Mahesh

--
--
You received this message because you are subscribed to the Google
"QTP - HP Quick Test Professional - Automated Software Testing"
group.
To post to this group, send email to Mercu...@googlegroups.com
To unsubscribe from this group, send email to
MercuryQTP+...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/MercuryQTP?hl=en

---
You received this message because you are subscribed to the Google Groups "QTP - HP Quick Test Professional - Automated Software Testing" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mercuryqtp+...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[mizan rahman]

Thanks a lot to Uma and Vivek. if you guys could explain why Excel.Application is better than importing Excel file to datatable. i will be waiting for the answer, cause i really need to learn this issue. i appreciate your help.

[Vineeth]

Killing excel object is a big deal, as long as  you handle it properly through script excel.application is good.

Note-data table is a in built option of qtp, use it.

Excel.application is a 3rd party tool, avoid it if you are a learner.

Regards,
Vineeth

---

From: mizan rahman
Sent: ‎16-‎05-‎14 ಅಪರಾಹ್ನ 07:48
To: mercu...@googlegroups.com
Subject: Re: Datatable vs excel.application

[uma mahesh]

In my experience, using excel. application scripting will be more comfortable.

Because normally in most of the projects we will get test data only in excel sheet and after executing scripts showing the results in excel sheets with hyperlinks to the screen shots will look good to the client.  

if we are using datable it is double time work. we need to import data to the tool and made some changes and again export into excel sheets. instead of this why dont we make changes directly in excel sheet.

Regards

Mahesh

[mizan rahman]

Thanks all of you.