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

Is it posible to import Excel data to gridview

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (2)