VB.Net – Excel Automation

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

  • VB.Net Version: 2017 Enterprise
  • Excel Version: Excel Professional 2016

Interop

COM Interop is a technology included in the .NET Framework Common Language Runtime (CLR) that enables Component Object Model (COM) objects to interact with .NET objects, and vice versa. COM Interop aims to provide access to the existing COM components without requiring that the original component be modified.

OLEDB

OLE DB (Object Linking and Embedding, Database, sometimes written as OLEDBor OLE-DB), an API designed by Microsoft, allows accessing data from a variety of sources.

Others

In due time we will explore other options as well.