Decrypt Excel files and import them into Alteryx (without Excel installed!)

Question

This macro will use python and openpyxl/msoffcrypto-tool libraries to decrypt any given files with the provided password, and save a new version of it without encryption. It doesn't require the machine running it to have Excel installed, so it's perfect for server environments.

SAMPLE INPUT:

encrypted_file_pathencrypted_file_passworddecrypted_file_new_pathC:\...\Input\ExcelSample_1.xlsx123C:\...\Output\ExcelSample_1.xlsxC:\...\Input\ExcelSample_2.xlsx456C:\...\Output\ExcelSample_2.xlsx

OBS: The python libraries were added as assets on the package.

WF_DECRYPT_EXCEL_FILES.yxzp

flying008 · Answer

Hi, @hfibrahim

Dear, you need to install openpyxl and msoffcrypto-tool to run the macro first.

hfibrahim · Answer

Hi All,

sorry, i am facing error while running this macro. can someone please help me to execute this.

hfibrahim · Answer