if (strFileType.Trim() == ".xls") { connString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + Npath + ";Extended Properties='Excel 12.0;HDR=No;'"; } else if (strFileType.Trim() == ".xlsx") { connString = "Provider=Microsoft.ACE.OLEDB.8.0;Data Source=" + Npath + ";Extended Properties=\"Excel 8.0;HDR=No;IMEX=1\""; } //Updating data //on Calculate Button conn = new OleDbConnection(connString); cmd.CommandText = "update [ROLLED SECTION$C5:C5] set F1='" + txtBeamLength.Text + "'"; cmd.ExecuteNonQuery(); //result //on Show result button string qry = "SELECT * FROM [" + ddlSectionType.Text + "$A20:F25]"; cmd = new OleDbCommand(qry , conn); OleDbDataAdapter da = new OleDbDataAdapter(); da.SelectCommand = cmd; DataSet ds = new DataSet(); da.Fill(ds); GridView1.DataSource = ds; GridView1.DataBind(); I am using ASP.net and c # for back end. Please help me in this I am trying to resolve this issue from long time..... What I have tried: Using Interop excel file object its not saving file after uploading site on server and I don't want to show this excel to user.
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)