HOW TO GET DATA FROM EXCEL INTO TEXT BOX USING IN C# IN ASP

Question

HI FRIENDS,

PLEASE HELP ME IN GETTING DATA FROM EXCEL SHEET TO TEXTBOX IN C# UISNG ASP.NET

FOR EXAMPLE:

IF I HAVE A NAME COLUMN IN EXCEL SHEET THEN THE NAME IN THE EXCEL-COLUMN HAS TO BE DISPLAYED IN TEXTBOX IN ASP

EXCEL SHEET

NAME

CHIRU

VENU

NAVEEN

ASP . PAGE

BROWSE EXCEL SHEET	G:\EXCEL1	UPLOAD

HERE ALL THE NAME CHIRU HAS TO BE DISPLAYED IN THE EXCEL SHEET...

Satyapriya Nayak · Answer

Hi chiranjeevi, Try this... Here is an example to Display uploded excel files in Gridview. Untitled Page Text="Upload Excel Files" OnClick="ButtonUpload_Click" /> Text="View Excel Data" 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 Display_excel_files_in_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 If this post helps you mark it as answer

HOW TO GET DATA FROM EXCEL INTO TEXT BOX USING IN C# IN ASP

Answers (1)