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);
}
