public List <ExcelSheet> GetSheets(string fileName, string fileExt) { var sheets = new List <ExcelSheet>(); var schema = GetExcelSchema(fileName, fileExt); foreach (DataRow item in schema.Rows) { var sheetName = item?["TABLE_NAME"]?.ToString(); if (string.IsNullOrWhiteSpace(sheetName) || !Constants.ExcelNameEndWithCharacters.Any(x => sheetName.EndsWith(x))) { continue; } var excelSheet = new ExcelSheet() { Name = sheetName }; sheets.Add(excelSheet); } return(sheets); }