Reading password protected file using excel link - R Code

[SH_94]

Dear community,

i would lilke to ask how can we ask the alteryx to read all the data in the excel file instead of just one row?

Screenshot below is the original data 

However, the out put show differently as per screenshot below:It only show one column only. May i know if the tools can read all the data available in the excel?

Dear @danilang. 

Sorry to bother you and it would be really appreciated if you assist me on this query.

Many thanks in advance

[IraWatt]

Hey @SH_94,

You definitely can do this, I have a macro on the gallery which can do this Password Protected Excel Input Tool - Alteryx Community:

Sadly couldn't test on your file as the directory tool is linked to your PC 

Any questions or issues please ask :)
HTH!
Ira

[SH_94]

Hi @IraWatt ,

I try to use the macro but i cannot link to my input file as per screenshot below despite i close all the files

I choose the file input and select to connect a file as per screeshot below but it does not work for me.

Do you know the reason behind this?

Thank you 

[IraWatt]

Once you have downloaded it just bring it into the workflow like this:

Then make sure to pass your file location and password:

[SH_94]

Hi @IraWatt ,

I think mine view one a bit different with yours.

Can you resent here the macro again?

[IraWatt]

@SH_94 what you have open is the macro file:

To bring it onto as a macro tool right click the canvas in a different workflow-> click insert-> macro-> browse -> then find the password macro file 

[SH_94]

Hi @IraWatt ,

would you mind to send me the following file and i try to open from there :

Thank you and hope to hear from you soon.

[IraWatt]

Hey @SH_94,

I've updated the gallery tool to come with an example workflow hope that helps.