How to read the data from Excel macro-enabled workbook (XLSM) file in Alteryx

[AlteryxLearner07]

Hi Folks,

Could you please help me read the data from the Excel macro-enabled workbook (XLSM ) zip file in Alteryx? I'm able to unzip the file with a macro then after I have trouble opening the file with a respected password. 

I tried to open the file with a R code (

https://knowledge.alteryx.com/index/s/article/R-code-to-extract-password-protected-file-in-Designer

) still not I'm unable to open the file.

Any ideas on how to read the data from a zipped and password-protected XLSM file?

Thanks in Advance.

[caltang]

A zipped file and a protected file are two different things. What are you doing exactly?

Is it...

Scenario A: There is an XLSM file in a zipped folder

Scenario B: There is a protected XLSM file in a zipped folder

Scenario C: There is a protected XLSM file in a zipped + password protected folder

Scenario D: There is a XLSM file in a zipped + password protected folder

Which one? Can you also provide sample data?

If you have a workflow, kindly export it here for everyone to see.

[AlteryxLearner07]

Hi caltang

Thank you for your response.

Scenario B: There is a protected XLSM file in a zipped folder.

[caltang]

Then I suggest to unzip the folder, then use the folder path, then use the R Tool with the password to access the password protected file... That should do it.

[caltang]

If you want a fully automated end-to-end process - unzip the zipped folder in Alteryx like so:

• https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Can-Alteryx-unzip-a-file-as-pa...
• https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Can-I-unzip-a-file-within-my-w...
• https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/How-to-unzip-a-file-using-Alte...