Excel automation vs. Ado.Net

[Guest]

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

 

[Miha Markic [MVP C#]]

Hi,

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.

 

[Guest]

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.

 

[Mike Newton]

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.