Can an Azure Logic App read an excel file from a storage account?

Question

I have an excel spreadsheet residing in a container in an azure storage account.

I can use an Azure Logic App with the "Get Blob Content" to access the file. But I cannot find any documentation discussing actually reading the file within the Azure Logic App from blob storage. Note that there are connectors for accessing Excel files in OneDrive or Office365 but not from a storage account container.

Despite furious searching I have not found any discussion of this use case in Microsoft Documentation or otherwise. Any links would be appreciated.

What is the best approach to read/search an excel file in Azure Logic Apps from Blob Storage?

What do you mean of read an excel file ? Get the content of the excel file in logic app ? — Hury Shen
Correct. Ideally I want to be able to search the excel file for a value and return the rows that match my search criteria. Then use the data from that row in the logic app to say, send an email. This probably means looping through rows and checking the for content in a particular column. — garthoid
It seems not exist a good solution to implement this requirement in logic app. Use azure function and write code by yourself as Thiago mentioned is a solution. And do you mind upload the excel to OneDrive and then you can use actions of OneDrive connector. — Hury Shen

Thiago Custodio Thiago Custodio · Accepted Answer · 2021-01-14T18:10:30

You can add an Azure Function to your workflow and easily read the contents of your spreadsheet:

public class ExcelFileContentExtractorService : IExcelFileContentExtractorService
{
    public ExcelFileRawDataModel GetFileContent(Stream fileStream)
    {
        IDictionary<string, string> cellValues = new Dictionary<string, string>();
        IWorkbook workbook = WorkbookFactory.Create(fileStream);
        ISheet reportSheet = workbook.GetSheetAt(0);

        if (reportSheet != null)
        {
            int rowCount = reportSheet.LastRowNum + 1;
            for (int i = 0; i < rowCount; i++)
            {
                IRow row = reportSheet.GetRow(i);
                if (row != null)
                {
                    foreach (var cell in row.Cells)
                    {
                        var cellValue = cell.GetFormattedCellValue();
                        if (!string.IsNullOrEmpty(cellValue))
                        {
                            cellValues.Add(cell.Address.FormatAsString(), cellValue);
                        }
                    }
                }
            }
        }

        return new ExcelFileRawDataModel()
        {
            Id = cellValues["A6"],
            CarBrand = cellValues["B6"],
            CarModel = cellValues["C6"],
            CarPrice = decimal.Parse(cellValues["D6"]),
            CarAvailability = int.Parse(cellValues["E6"])
        };
    }
}

source: https://daniel-krzyczkowski.github.io/Extract-Excel-file-content-with-Azure-Logic-Apps-and-Azure-Functions/

Can an Azure Logic App read an excel file from a storage account?

3 Answers