Is it posible to import Excel data to gridview

Question

hi is it posible to import Excel data to gridview  add new values and export back. Thanks in advance

Mahesh Chand · Answer

Yes. Search this website for import excel into GridView. You will see several articles. To export it back search Export. There are two different articles.

Satyapriya Nayak · Answer

Hi Ilkin Import Excel data to gridview Try this... Untitled Page Text=Upload Excel Files OnClick=ButtonUpload_Click /> Text=View Excel Data in Gridview OnClick=ButtonView_Click /> Please select an Excel file to import: Text=Upload File OnClick=ButtonUploadFile_Click /> BorderStyle=None BorderWidth=1px CellPadding=3 CellSpacing=2> using System; using System.Collections; 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; namespace Import_Excel_data_to_gridview { public partial class _Default : System.Web.UI.Page { protected void ButtonUploadFile_Click(object sender EventArgs e) { if (FileUploadExcel.HasFile) { try { FileUploadExcel.SaveAs(Server.MapPath(~/ExcelImport.xls)); LabelUpload.Text = Upload File Name:  + FileUploadExcel.PostedFile.FileName +   + Type:  + FileUploadExcel.PostedFile.ContentType +  File Size:  + FileUploadExcel.PostedFile.ContentLength +  kb ; } catch (System.NullReferenceException ex) { LabelUpload.Text = Error:  + ex.Message; } } else { LabelUpload.Text = Please select a file to upload.; } } protected OleDbCommand ExcelConnection() { string ConnStr = Provider=Microsoft.Jet.OLEDB.4.0; + Data Source= + Server.MapPath(ExcelImport.xls) + ; + Extended Properties=Excel 8.0;; OleDbConnection Con = new OleDbConnection(ConnStr); Con.Open(); OleDbCommand com = new OleDbCommand(SELECT * FROM [sheet1$] Con); return com; } protected void ButtonView_Click(object sender System.EventArgs e) { PanelUpload.Visible = false; PanelView.Visible = true; PanelImport.Visible = false; OleDbDataAdapter oledbda = new OleDbDataAdapter(); oledbda.SelectCommand = ExcelConnection(); DataSet ds = new DataSet(); oledbda.Fill(ds); GridViewExcel.DataSource = ds.Tables[0].DefaultView; GridViewExcel.DataBind(); } protected void ButtonUpload_Click(object sender System.EventArgs e) { PanelUpload.Visible = true; PanelView.Visible = false; PanelImport.Visible = false; } } } Thanks