Unlock excel file when using azure data factory

Question

Unlock excel file when using azure data factory

Lars Schlaepfer 21

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

KranthiPakala-MSFT 45,982 Reputation points Microsoft Employee

2021-02-17T21:57:11.927+00:00

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
KranthiPakala-MSFT 45,982 Reputation points Microsoft Employee

2021-02-19T00:23:45.323+00:00

Hi @Lars Schlaepfer

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

KranthiPakala-MSFT 45,982 Reputation points Microsoft Employee

2021-02-17T21:57:11.927+00:00

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
KranthiPakala-MSFT 45,982 Reputation points Microsoft Employee

2021-02-19T00:23:45.323+00:00

Hi @Lars Schlaepfer

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

Answer 1

Nandan Hegde 27,391 MVP

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.

Unlock excel file when using azure data factory

0 additional answers

Activity