Net-informations.com
SiteMap  | About    

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.

VB.Net

C#

NOTE: While updating the Excel file, the updating column data should exist in the excel file.

Default.aspx


Click the following links to see full source code

C# Source Code
VB.NET Source Code
default.aspx.cs
default.aspx.vb






net-informations.com (C) 2018    Founded by raps mk
All Rights Reserved. All other trademarks are property of their respective owners.