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.
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.
Thank you for your response.
Scenario B: There is a protected XLSM file in a zipped folder.
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.
If you want a fully automated end-to-end process - unzip the zipped folder in Alteryx like so: