Introduction:
In this article i am going to explain about how to insert/update the excel spreadsheet data using asp.net/c#.
Main:
using System.Data.OleDb;
string connectionString = "Provider=Microsoft.Jet.OleDb.4.0; data source=c:\\emp.xls; Extended Properties=Excel 8.0;";
string selectString = "Insert into [Sheet1$] values(1,'James','50000','Manager')";
OleDbConnection local_conn = new OleDbConnection(connectionString);
OleDbCommand cmd = new OleDbCommand(selectString,local_conn);
local_conn.Open();
cmd.ExecuteNonQuery();
local_conn.dispose();
using System.Data.OleDb; string connectionString = "Provider=Microsoft.Jet.OleDb.4.0; data source=c:\\emp.xls; Extended Properties=Excel 8.0;"; string selectString = "Insert into [Sheet1$] values(1,'James','50000','Manager')"; OleDbConnection local_conn = new OleDbConnection(connectionString); OleDbCommand cmd = new OleDbCommand(selectString,local_conn); local_conn.Open(); cmd.ExecuteNonQuery(); local_conn.dispose(); |
Conclusion:
Hope this helps,
Happy Coding.