Getting ready

In this recipe, we will create the activity trigger named ReadExcel_AT function that reads the data from the blob 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 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.Storage
Install-Package EPPlus