Export SQL database data using logic apps to a password protected Excel file

MrFlinstone 481 Reputation points
2020-06-15T22:49:33.003+00:00

Hi All.

I have a logic app solution which exports data from a Azure SQL database onto csv file, I will now like to change is such that it exports data to a password protected file (excel) .The password will be static.

Azure SQL Database
Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
2,855 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Samara Soucy - MSFT 5,051 Reputation points
    2020-06-22T20:55:59.103+00:00

    This isn't currently possible inside Logic Apps, and it does come with some complications in .NET. Office 365 doesn't support password protecting workbooks, so you can't do this through the Graph API.

    That leaves us with 2 options:

    1. Use the Microsoft.Office.Interop.Excel library for .NET to set up and protect your document. This library actually calls the installation of Office on that machine to complete tasks, so you would need to setup a Windows VM with Office installed to run it.
    2. Work with a 3rd party library that includes this functionality. There are a few out there, and whether you need a VM or could use something like Functions depends on the capabilities of that particular package.
    0 comments