Input Data (5): No Sheet Specified, you must specify a sheet error
- 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
I am looking for some help on an issue using the File Browse with and Action and Input Data tools and getting an error message. I used an old post to make sure that I have it configured correctly. Solved: File Browse - No sheet specified - Alteryx Community I have tried the same things as in this post but getting a Input Data (5): No Sheet Specified, you must specify a sheet error. I am unable to provide an example of my workflow since it is on a client computer. Can anybody help solve this for me? I may be able to mock up a dummy workflow on my end if needed to show and example of what is happening.
Solved! Go to Solution.
- Labels:
- Interface Tools
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Have you Debugged your app in the Interface Designer to make sure the File Browse is updating the Input Data correctly? In most cases, it will be your Action tool!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Show us a screenshot of your debug if you can
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I did and it doesn't look like the file is being updated in the Input Data when I run it. In Action I have 'Update Value' then the File - Value with the Path of the file for the Input Data template, then I have Replace a specific string checked with the path and file name of the template.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Here are the screenshots of an example of the workflow and the debug
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@alexnajm I just posted up my screenshots
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Can you just do "Update Input Data Tool" as your action?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@alexnajm still same error.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
It’s all working fine for me, so it’s hard to shoot in the dark without seeing what you are doing. Are you selecting a different file format than xlsx?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@alexnajm can you send me an example workflow of what you ran?
