Reading Excel data using activity functions

In this recipe, we will retrieve all data from specific Excel sheets by writing an activity function.

Let's now make some code changes to the Orchestration function by writing a new activity function that can read data from an Excel sheet that has been uploaded to the blob container.

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:...