How to integrate excel with asp .net

Question

Hi All I have following Requirement please can anybody help me. i have excel file with predefined template as follows with Emp.xls EID (B5): EName(D5): Designation(B6): Now i created webform with the following textboxes txtEID txtName & txtDesignation with Submit button now my requirement is If i click submit button the values which is taken from the user through textboxes will be copied into the following positions in the emp.xls file such as txtEID value-----> C5cell in Excel file txtName value --->E5cell in Excel file txtDesignation value--> B6cell in Excel file and the excel file has to save in some location with the filename of with Emp_EID(ID may vary to employee by employee) how can i achieve this...

SIVA · Answer

ya exactly My req is different. i need to insert those values into particular cells in predefined excel file. you can find the requirement in my thread please find the requirement & suggest me how can i get that

Satyapriya Nayak · Answer

We have to create a test. xls file inside the project directory.And name the three columns in the sheet as EIDENameDesignation. So when you will insert the records it will go on adding to it. I think your requirement is different.

SIVA · Answer

Hi Its showing the following error The Microsoft Jet database engine could not find the object 'sheet1$'. Make sure the object exists and that you spell its name and the path name correctly Where i need to put my excel file.. This is the first time i am working with excel

Satyapriya Nayak · Answer

Hi Siva Try this... Untitled Page onclick=Button1_Click /> using System; using System.Configuration; using System.Data; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Xml.Linq; using System.Data.OleDb; using System.Data.SqlClient; using System.Text; public partial class _Default : System.Web.UI.Page { OleDbConnection con; OleDbCommand com; string str; protected void Button1_Click(object sender EventArgs e) { try { com = new OleDbCommand(); con = new OleDbConnection(@Provider=Microsoft.Jet.OLEDB.4.0;Data Source= + Server.MapPath(test.xls) + ;Extended Properties=Excel 8.0); con.Open(); com.Connection = con; str = Insert into [sheet1$] (EIDENameDesignation) values(' + TextBox1.Text + '' + TextBox2.Text + '' + TextBox3.Text + '); com.CommandText = str; com.ExecuteNonQuery(); con.Close(); Response.Write(Records Added Successfully); TextBox1.Text = ; TextBox2.Text = ; TextBox3.Text = ; } catch (Exception ex) { Response.Write(ex.Message); } } } Thanks