VB.Net – Excel automation using Oledb

The System.Data.OleDb namespace is the.NET Framework Data Provider for OLE DB. The.NET Framework Data Provider for OLE DB describes a collection of classes used to access an OLE DB data source in the managed space. OleDbCommand, OleDbConnection, OleDbDataAdapter and few others are some of the classes which we will be using in our examples below

 

  1. Creating an Excel File (Under Renovation)
  2. Creating an Excel Sheet (Under Renovation)
  3. Adding column headers and inserting data (Under Renovation)
  4. Open an Excel File (Under Renovation)
  5. Modifying Data (Under Renovation)
  6. Deleting Data (Under Renovation)