In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Workflow

anupgupta12
8 - Asteroid

Does somebody know if Alteryx can read macro enabled excel worksheet?

6 REPLIES 6
atcodedog05
22 - Nova
22 - Nova

Hi @anupgupta12 

 

I guess it will read only the displayed data. If you have a excel with macro you can try it out.

anupgupta12
8 - Asteroid

I think, it does not read, when we try to bring macro enabled file through input tool, this file doesn't show up in folder for Alteryx to read.

atcodedog05
22 - Nova
22 - Nova

Hi @anupgupta12 

 

What's the extension of the file

anupgupta12
8 - Asteroid

So basically, I was trying to get output to a macro enabled file, but I couldn't do that.

anupgupta12
8 - Asteroid

.xlsm

atcodedog05
22 - Nova
22 - Nova

Hi @anupgupta12 

 

It should be possible.  Do you have Access db driver 2010 installed. If not you, you need to have it installed maybe then you can read the file.

 

https://www.microsoft.com/en-us/download/details.aspx?id=13255

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Importing-data-from-xlsm-format/td-p/6... 

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/How-do-I-input-xlsb-files/td-p/555604 

 

Hope this helps ðŸ™‚

Labels
Top Solution Authors