By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,241 Members | 799 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,241 IT Pros & Developers. It's quick & easy.

Excel automation vs. Ado.Net

P: n/a
What are the advantages/disadvantages of using Excel Automation vs. Ado.Net
when it comes to reading and writing records in an Excel workbook with Visual
C#.Net?

Thanks.

Mansi
Nov 16 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Hi,

"Mansi" <Ma***@discussions.microsoft.com> wrote in message
news:BD**********************************@microsof t.com...
What are the advantages/disadvantages of using Excel Automation vs.
Ado.Net
when it comes to reading and writing records in an Excel workbook with
Visual
C#.Net?


Yes, automation gives you plenty of functionality more as opposed to ado.net
(in the case of Excel).
For example: formating.

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
miha at rthand com
www.rthand.com
Nov 16 '05 #2

P: n/a
Using Excel as a database relies on worksheet range names being correctly
defined, not to mention correct columnar layout, which isn't necessarily
always the case. Stick with automation.

"Miha Markic [MVP C#]" wrote:
Hi,

"Mansi" <Ma***@discussions.microsoft.com> wrote in message
news:BD**********************************@microsof t.com...
What are the advantages/disadvantages of using Excel Automation vs.
Ado.Net
when it comes to reading and writing records in an Excel workbook with
Visual
C#.Net?


Yes, automation gives you plenty of functionality more as opposed to ado.net
(in the case of Excel).
For example: formating.

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
miha at rthand com
www.rthand.com

Nov 16 '05 #3

P: n/a
Mansi wrote:
What are the advantages/disadvantages of using Excel Automation vs. Ado.Net
when it comes to reading and writing records in an Excel workbook with Visual
C#.Net?

Thanks.

Mansi


Excel automation is slow compared to ADO.NET, from my experience.
Unless you have special formatting needs, it's way faster to write out a
CSV file.
Nov 16 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.