How to bypass 'Select A Sheet' dialogue when importing Excel file using Dynamic Input?
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Labels:
- Dynamic Processing
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@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-sh...
?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@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.
