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

Question

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:

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

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

JarekSkudrzyk · Answer

@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.

lostipod12 · Answer

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 · Answer

@lostipod12 hi, have you tried solution by @mceleavey from this post:
https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Excel-file-input-without-asking-for-sheet-name/td-p/326086

?