Load Excel for Data Analysis through C# Program

ExcelLoader.cs

using System.Data.OleDb;
using System.Data;

 protected void Button1_Click(object sender, EventArgs e)
 {
            string fileName = "C:\\Enter\\Location\\filename.xls"; // Need to enter the file location - note xls file extension
            var conString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" +
                                        fileName + ";Extended Properties=\"Excel 8.0;HDR=Yes;IMEX=2\"";
            /*In case you have .xlsx file try
             conString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + 
                        fileName + ";Extended Properties=\"Excel 12.0;HDR=Yes;IMEX=2\""; */
            // This is the name of your worksheet you want to open                          
            var adapter = new OleDbDataAdapter("SELECT * FROM [Sheet1$]", conString); 
            var ds = new DataSet();
            adapter.Fill(ds, "TestData");
            DataTable data = ds.Tables["TestData"]; 
            // Now we have data in table format ready to be analyzed
            
            
 }