private void OnInputFileChanged()
{
SelectedSheet = String.Empty;
IsValid = false;
try
{
ExcelSheetInfoProvider sheetInfoProvider = new ExcelSheetInfoProvider(InputFileName);
SheetNames = sheetInfoProvider.GetSheetNames();
}
catch (Exception)
{
SheetNames = new List <string>();
}
}
public static bool IsSheetPresent(this ExcelSheetInfoProvider infoProvider, string sheetName)
{
return(infoProvider.GetSheetNames().Select(x => x.ToLower()).Contains(sheetName.ToLower()));
}