Input Data (5): No Sheet Specified, you must specify a sheet error

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.

Interface Tools

Accepted answers

alexnajm

Actually then wait a second, my example DOES work then with reading in one sheet from an excel with multiple sheets. I don't understand the error you are running into or what you want that's different than the example I provided - you can select the file with the complaints sheet and it works.

Use my example, and tell me what's broken - otherwise please describe further what you need because I must be missing something. Ideally I would like your workflow since it's difficult to help further from here since my solution works based on your description

All comments

alexnajm

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!

alexnajm

Show us a screenshot of your debug if you can

dmccombie

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.

dmccombie

Here are the screenshots of an example of the workflow and the debug

Screenshot 2025-02-13 173609.png Screenshot 2025-02-13 173639.png Screenshot 2025-02-13 173658.png Screenshot 2025-02-13 173713.png

dmccombie

@alexnajm I just posted up my screenshots

alexnajm

Can you just do "Update Input Data Tool" as your action?

dmccombie

@alexnajm still same error.

alexnajm

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?

dmccombie

@alexnajm can you send me an example workflow of what you ran?

alexnajm

I can, but you can also just check out the File Browse example in designer

alexnajm

Works fine for me

File Browse Example.yxwz

dmccombie

@alexnajm if you can, the example doesn't have something specific that addresses an excel spreadsheet with multiple sheets on it

alexnajm

Well that's a big difference that wasn't known before! Please provide this in the description next time

What is your end goal then?

dmccombie

so i need to browse for a file with multiple sheets in it using the interface tool then bring in the 'complaints' sheet (in this example) to the input data tool then perform some filters on the file then eventually output the sheet that I brought in.

alexnajm

dmccombie

@alexnajm Thank you for your help with this. For the File Browse section, I had it as Arbitrary File Selection, so when I selected the file, it did not prompt me for a Sheet to select. When the Standard Database File format is selected, it prompts to select the Sheet that you want from the file. This will work for now, but is there a way that would not need the user to specify the sheet to select from?

alexnajm

Yes it's possible, but I personally don't think it's a good idea based on the trouble that it was causing. You would have the Action tool Update via Formula and strip off the sheet name at the end to replace it with "complaints" so it grabs that sheet no matter what

But from a user experience, just ask them in the instructions to select the correct sheet (likely named "complaints" but in theory it could be any name)

dmccombie

@alexnajm makes sense. thanks for all the help. sorry about the confusion....

alexnajm

It’s ok - just make sure to mark one of my responses as a solution!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703