meds-processor, p3, s6

HzzoExcelParser.cs

static ISheet OpenWorkbookSheetWithNpoi(FileStream stream, HzzoMedsDownloadDto med, HzzoMedsDownloadDto latestMed)
{
  ISheet drugListSheet = null;

  try
  {
    if (med.FileName.ToLowerInvariant().EndsWith(".xls"))
    {
      var hssfWorkbook = new HSSFWorkbook(stream);
      drugListSheet = hssfWorkbook.GetSheetAt(0);
    }
    else
    {
      var xssfWorkbook = new XSSFWorkbook(stream);
      drugListSheet = xssfWorkbook.GetSheetAt(0);
    }
  }
  catch
  {
    // TODO: log error, awh we will do that l8er
    latestMed.Href += " - WORKSHEET COULD NOT BE PARSED";
  }

  return drugListSheet;
}