Read Excel File in C#

Read Excel File in C#:

Design a form in Visual studio add a button ,Add a folder upload and paste an excel data file.

Button Click event write the below code:

Coding:

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;

public partial class _Default : System.Web.UI.Page 

{

    protected void Page_Load(object sender, EventArgs e)

    {

    }

    protected void Button1_Click(object sender, EventArgs e)

    {

        string target = Server.MapPath("~/Upload");

        if (FileUpload1.HasFile)

        {

            FileUpload1.SaveAs(System.IO.Path.Combine(target, FileUpload1.FileName));

            string connString = string.Format("Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0};Extended Properties=Text;", System.IO.Path.GetDirectoryName(target + "\\" + FileUpload1.FileName));

            string cmdString = string.Format("SELECT * FROM {0}", System.IO.Path.GetFileName(target + "\\" + FileUpload1.FileName));

            OleDbDataAdapter dataAdapter = new OleDbDataAdapter(cmdString, connString);

            DataSet dataSet = new DataSet();

            dataAdapter.Fill(dataSet);

            GridView1.DataSource = dataSet.Tables[0];

            GridView1.DataBind();

        }       

    }

}

If this is not satisfactory for you write us to get assistance Contact Us

Learn more about excel:Shareyourconscience