Updating excel using ado net
See Connection Pooling to create and configure a pool.
A Name in the Excel workbook is a section of data that will be given a name and a range.
In C# without using Excel Object we can insert , edit , delete , select etc. Here we are using Ole Db Connection , Ole Db Data Adapter , Data Set for doing these operations in an Excel file.
This manual describes how to install and configure My SQL Connector/ODBC, the driver that enables ODBC applications to communicate with My SQL servers, and how to use it to develop database applications.
The example program had examples of querying a single "Name" (or table if that is the way you want to think about it) , two spreadsheets with both spreadsheets having a "Name" associated with it, inserting data into a spreadsheet and updating data in a spreadsheet.
The basic steps necessary for using the data is fairly simple and just like using SQL or any other database.
First you make a connection to the spreadsheet using the connection string listed above.