Reading password protected file using excel link - R Code

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

Excel.yxmd

Common Use Cases

Accepted answers

All comments

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.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703