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