This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(166.4, 44%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELS%3C/text%3E%3C/svg%3E)
Hello,
I'm currently working with data that I receive every 1st of the month. This data is delivered in my email as an excel file but it's protected with a password. I use Azure Logic App to move the attachment (excel file) to a blob storage. This file is then used within Azure Data Factory to copy it into my database table.
To automate this process I need a solution to enter this password automatically when I want to copy it into my database with ADF.
Is there someone that encountered the same problem and has found a solution?
Kind regards,
Lars
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(134.4, 9%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKM%3C/text%3E%3C/svg%3E)
Hi LarsSchlaepfer-1902,
Welcome to Microsoft Q&A forum and thanks for reaching out.
Just checking in to see if the below suggestion from @Nandan Hegde was helpful. If this answers your query, please do click “Accept Answer” and/or Up-Vote, as it might be beneficial to other community members reading this thread. And, if you have any further query do let us know.
Thank you
We still have not heard back from you. Just wanted to check if you still need assistance on this issue? Otherwise, let us know and we will continue to engage with you on the issue. Please do consider to click on "Accept Answer" and "Up-vote" on the post that helps you, as it can be beneficial to other community members
Thank you
hey @Lars Schlaepfer ,
you can use python code to open pwd protected excel file :
https://stackoverflow.com/questions/19450837/how-to-open-a-password-protected-excel-file-using-python
via Azure functions and call Azure functions via ADF for the overall data flow.