Excel Reader with sheet_selection flow variable

In looking for a solution, I’ve come across a few topics that are similar to the issue I’m having, but haven’t had any success. I have an excel file that contains 14 different sheets, labeled by state abbreviation codes. I’m attempting to pass a string flow variable to the sheet_selection parameter within the Excel Reader node. I’m not sure why but I’m getting an error message that says “No sheet selection setting ‘CA’ available. See node description”. I’ve attempted a couple of solutions including the read excel sheet names and then filtering based on the single-selection variable. Even this doesn’t work so I know it’s not a matter of sheet name syntax. Other articles have suggested to make sure “Select sheet with name” is chosen under sheet selection. I have verified this and am still running into issues. I’m not really sure what I could possibly be doing wrong so any suggestions are greatly apricated.

Excel Sheets




Workflow3

Hi @JGebhard

Not tested by myself but a shot in the dark. I think you have to move your “single-selection” flow variable one box down to sheet_name (instead of sheet_selection).
gr. Hans

2 Likes

Wow - that was it. Thanks so much

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.