Read data from excel (.xlsx) using c#

Hi,
Try this code.

private DataTable ExcelToDataTable()
    {
        string conStr = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\Temp\\Sample.xlsx;Extended Properties='Excel 12.0 Xml;HDR=YES'";
        
        OleDbConnection connExcel = new OleDbConnection(conStr);
        connExcel.Open();
        try
        {

            OleDbCommand cmdExcel = new OleDbCommand();
            OleDbDataAdapter oda = new OleDbDataAdapter();
            DataTable dt = new DataTable();
            cmdExcel.Connection = connExcel;

            /*Get the name of First Sheet*/

            DataTable dtexcelSchema;
            dtexcelSchema = connExcel.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);
            string sheetName = dtexcelSchema.Rows[0]["TABLE_NAME"].ToString();
            connExcel.Close();

            /*Read Data from First Sheet*/
            connExcel.Open();
            cmdExcel.CommandText = "SELECT * FROM [" + sheetName + "]";
            oda.SelectCommand = cmdExcel;
            oda.Fill(dt);
            connExcel.Close();

            return dt;
        }
        catch (Exception ex)
        {
            connExcel.Close();
            throw ex;
        }
    }

public partial class MainWindow : Window
{
public MainWindow()
{
InitializeComponent();
ReadFromExcel();
}


private void ReadFromExcel()
{
string con =
@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:\\2015.xlsx;; Extended Properties=Excel 12.0;";
using (OleDbConnection connection = new OleDbConnection(con))
{
connection.Open();
OleDbCommand command = new OleDbCommand("select * from [Sheet1$]", connection);
OleDbDataReader dr = command.ExecuteReader();
DataTable tab = new DataTable();
tab.Load(dr);
}

}
}