private void LoadFile(object state)
{
Console.WriteLine($"{DateTime.Now} LoadFile(..) method has been invoked.");
var fileName = "current.xlsx";
var stream = CloudHelper.ReadBlobAsync(storageConnectionString, blobContainerName, fileName).Result;
stream.Seek(0, SeekOrigin.Begin);
using (var excelPackage = new ExcelPackage(stream))
{
var excelWorkSheets = excelPackage.Workbook.Worksheets;
foreach (var worksheet in excelWorkSheets)
{
Console.WriteLine($"\t - Processing worksheet: {worksheet.Name}");
ProcessWorksheet(worksheet);
}
}
}
