VB.NET and Excel

This section is specifically dedicated to VB.Net and Excel.

Note: I hate to say this but this site is best viewed in Firefox. IE doesn’t show all the formatting correctly. :( I managed to change the formatting for this page so that you can view it on IE but can’t do it for the rest of the pages.

  • VB.Net Version: 2010 Ultimate
  • Excel Version: Excel Professional Plus 2010

Excel Automation Using Interop

We will be covering the following. In case you feel that I should be covering something besides the below then do drop me a line and I will include that.

Note: The below section takes you step by step and then in point 24 shows how to close and clean up. Before you start using the Samples from below, I would recommend you to read this point 2 (below) first.

Excel Automation Using Ace OLEDB data provider

  • VB.Net Version: 2013 Ultimate
  • Excel Version: Excel Professional Plus 2013