get the sheet name in excel mvc 5 c# .net

We can find the sheet name of excel file in MVC 5 C#.Net. The below code-sample is might help you to get sheet name.

// This method is used to get the sheet name in excel using c# MVC 5.net

private void GetSheetNameFromExcelFiles(string savedExcelFiles, List<UploadExcel> uploadExl, int CompanyID, int TenantID)

 {

     //Create connectionString using OleDbConnection

    OleDbConnection connectionString = new       OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + Server.MapPath(savedExcelFiles) + ";Extended Properties='Excel 12.0 xml;HDR=YES;'");

            connectionString.Open();

            DataTable Sheets = connectionString.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);

            foreach (DataRow dataR in Sheets.Rows)

            {

                string sheetStr = dataR[2].ToString().Replace("'", "");

                OleDbDataAdapter dataAdapter = new OleDbDataAdapter("select * from [" + sheetStr + "]", connectionString);

                var ds = new DataSet();

                dataAdapter.Fill(ds, "DataTable");

                DataTable data = ds.Tables["DataTable"]; 

            }

}