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

[#1]

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_path	encrypted_file_password	decrypted_file_new_path
C:\...\Input\ExcelSample_1.xlsx	123	C:\...\Output\ExcelSample_1.xlsx
C:\...\Input\ExcelSample_2.xlsx	456	C:\...\Output\ExcelSample_2.xlsx

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

[hfibrahim]

[hfibrahim]

Hi All,

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

[flying008]

Hi, @hfibrahim 

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