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.

How to bypass 'Select A Sheet' dialogue when importing Excel file using Dynamic Input?

lostipod12
6 - Meteoroid

Hello,

 

I have a macro which prompts a user to input an Excel file which has multiple sheets. The macro is designed to run through each sheet and process them individually. So far, the macro works just fine, I am able to load in an Excel file and spit out the results.

 

The input part of the macro looks like below:

 

lostipod12_0-1648832217016.png

 

 

The issue I am facing is that when I upload the Excel file, I am always prompted to select a sheet to read in:

 

lostipod12_1-1648832287601.png

 

I always always always want the macro to read in the first sheet. Every time. No exceptions.

 

 

Is there a way to program the interface tools or Dynamic Input tool to just accept the Excel file I uploaded and automatically use the first sheet?

 

Thank you,

 

Nick 

 

3 REPLIES 3
lostipod12
6 - Meteoroid

Hi Jarek,

 

Thank you for your reply.

 

I should have mentioned this in my original post, I didn't think that it would matter...

 

My solution will eventually exist as an Analytics App inside my company's Alteryx Gallery ðŸ˜¯

 

 

I read through the thread you shared.

 

One user writes, "If you are deploying by server, answer = no (well you can build the functionality, it just wouldn't work once loaded to the gallery), if you are deploying as app for designer users to run locally, then yes; but I imagine the answer is the former, so I won't elaborate how yet!"

 

Another user posted a workflow which doesn't accomplish what I need.

 

Another user posted a workflow which accomplishes what I need, but it relies on the Directory tool, which I believe won't work in Alteryx Gallery.


It looks like I might need to instruct my users to be careful to select the first worksheet after loading the file.

 

Thanks,

 

Nick

JarekSkudrzyk
11 - Bolide

@lostipod12 
I could not find any other suggestions.
Have you tried using some programming lanuage tools to do that - e.g. Python - I havent tried them but I think they can offer greater flexibilty.

Labels
Top Solution Authors