Here is the sample data extracted, visible in the Azure Cosmos DB Data Explorer: Public class ExcelFileContentExtractorService : IExcelFileContentExtractorService With this library, we can read both - older version of the Excel file (XLS) and the new one (XLSX). To extract the content, we are going to use NPOI library available as NuGet package. We need to create Blob Trigger Function App to react always when there is a new file created on the Azure Blob Storage. Once the Excel file is received, we can extract its content using Azure Function App. Then we want to store this file on the Blob Storage to make it available for the Azure Function. In this scenario, we want to trigger Logic App when a new email with attachment is received. We are going to start with Azure Logic App implementation. Extracted data is stored in the Azure Cosmos DB.Azure Function is triggered and Excel file is extracted.Excel file is stored on the Azure Blog Storage.An email with Excel file as an attachment is received.Code of this article is available on my GitHub here.

In the end, we are going to store extracted data in the Azure Cosmos DB. How to do it? Especially when there is a need to support the older file format (xls) and the new one (xlsx)? In this article, we will go through the implementation of the solution responsible for the automated extraction of the content from Excel files using Azure Logic Apps and Azure Function Apps. If email is received with an Excel file as an attachment, we would like to get this content and process it. Let’s talk about a specific scenario - extracting content from the Excel files. Extract Excel file content with Azure Logic Apps and Azure FunctionsĮxtracting file content in Azure sounds like an easy topic.

Xlsx file reader app