Read Excel File in C#

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:


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();
            GridView1.DataSource = dataSet.Tables[0];

If this is not satisfactory for you write us to get assistance Contact Us
Learn more about excel:Shareyourconscience
Read Excel File in C# Read Excel File in C# Reviewed by Tanuj on 8:18:00 am Rating: 5

No comments:

Powered by Blogger.