Excel automation vs. Ado.Net

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Hi,

Mansi said:
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?
Click to expand...

Yes, automation gives you plenty of functionality more as opposed to ado.net
(in the case of Excel).
For example: formating.
 
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.
 
Mansi said:
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
Click to expand...

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.
 
Back
Top