private static void AssertSheetExists(string excelFileName, string sheetName)
{
ExcelSheetInfoProvider sheetInfoProvider = new ExcelSheetInfoProvider(excelFileName);
if (!sheetInfoProvider.IsSheetPresent(sheetName))
{
throw new Exception(sheetName + ": sheet does not exist");
}
}
public ExcelReader(string filename, string sheetName, ILogger logger)
{
_logger = logger;
FileName = filename;
SheetName = sheetName;
AssertSheetExists(filename, sheetName);
_stream = ExcelSheetInfoProvider.GetFileStream(filename);
_package = new ExcelPackage(_stream);
_sheet = _package.Workbook.Worksheets[sheetName];
}
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()));
}