opening / modifying Excel spreadsheets in VB.Net

[Lee Moody]

I would like the ability to open an Excel spreadsheet in
VB.NET and be able to read and modify the spreadsheet
programatically. I've seen bits of code here and there
for doing so in SQL or Excel VBA or C# but nothing
comprehensive and specific to VB.NET.

Any help anyone can provide to point me in the right
direction would be greatly appreciated!

Thanks in advance.

-Lee

 

[Herfried K. Wagner [MVP]]

I would like the ability to open an Excel spreadsheet in
VB.NET and be able to read and modify the spreadsheet
programatically. I've seen bits of code here and there
for doing so in SQL or Excel VBA or C# but nothing
comprehensive and specific to VB.NET.

HOWTO: Automate Microsoft Excel from Visual Basic .NET
<http://support.microsoft.com/default.aspx?scid=kb;en-us;301982>

 

[Lee Moody]

Dude, you rock! That was exactly what I needed.

Thanks!

-Lee