Modify Excel file from ASP.NET
The following ASP.NET program modify the data in the excel file using OLEDB connection . In order to run this program you have to have an existing excel file with two column named as ID and NAME in the specified location of the connection string.
Data Source=ExcelFile.xls : you have to specify the Excel file location.
For updating data into an Excel file using OLEDB , we have to create an update statement like in SQL operations.
Dim sql As String = "Update [Sheet1$] set name = 'New Name' where id=2"
string sql = "Update [Sheet1$] set name = 'New Name' where id=1";
NOTE: While updating the Excel file, the updating column data should exist in the excel file.
Click the following links to see full source code