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.


connStr = "provider=Microsoft.Jet.OLEDB.4.0;Data Source='ExcelFile.xls';Extended Properties=Excel 8.0;";

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.



<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "">
<html xmlns="">
<head id="Head1" runat="server">
<title>Untitled Page</title>
	<form id="form1" runat="server">
	<asp:Button ID="Button1" runat="server" onclick="Button1_Click" Text="Button"
	Width="103px" />
	<asp:Label ID="Label1" runat="server" Text="Message : "></asp:Label>

Click the following links to see full source code

C# Source Code
VB.NET Source Code
default.aspx.vb (C) 2018    Founded by raps mk
All Rights Reserved. All other trademarks are property of their respective owners.