Encrypted Excel file - cannot open in Alteryx

[mprodanova]

Hello Community,

Can you help me figure out how I can use an encrypted excel file as an Output in Alteryx?

The content in the excel file (*xlsm) should be enabled and this is the reason I cannot see the details when I try to open it in Alteryx.

Thanks!

Margaritka

[IraWatt]

Hey @mprodanova,

Is this a password protected Excel file in which case you can try my tool: Password Protected Excel Input Tool - Alteryx Community

[mprodanova]

Hey, IraWatt,

No, it is not protected with a password.

[IraWatt]

How are you encrypting it @mprodanova ? I only know of encrypt with password.

[mprodanova]

It is not locked with a password. The file contains macros, so when you enable the content in Excel, the data loads.

Example:

Parent Product 1 = Fruits

Child Product 1.1 = Apple

Child Product 1.2 = Orange

etc.

So I guess my questions is - how to enable the macros/content in Alteryx?

[IraWatt · Accepted solution]

Ah okay, theres quite a good thread on doing this here @mprodanova  Solved: Run the excel macro using Alteryx - Alteryx Community they recommend this approach Triggering Excel Macros from the comfort of your Alteryx Workflow