Azure Serverless Computing Cookbook - Second Edition

Getting ready

In this recipe, we will create an activity trigger named ReadExcel_AT that reads data from the blob that's stored in the storage account. This activity trigger performs the following jobs:

1. Connects to the blob using a function, ReadBlob, of a class named StorageManager. 
2. Reads the data from the Excel sheet using a component called EPPlus. You can read more about it at https://github.com/JanKallman/EPPlus.
3. Returns the data from the Excel file as a collection of employee objects.

Next, install the following NuGet packages in the ExcelImport.DurableFunctions project:

Install-Package WindowsAzure.StorageInstall-Package EPPlus