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"];
}
}