I have a similar workflow to the one shown below.
Problem: I always have to manually change the Excel Reader Node Sheet
Question: if there a way to permanently set the Sheet, so I don’t have to change them manually?
Below is a simply workflow, but I have to change the sheet quite a few times.
Whenever I come back to this work flow, I manually change the "List Files" node directory.
^ Simplified view of workflow
^ I have to change the directory when I use new data.
^ When I click on the Excel Reader Node, I have to always correct the "Select the sheet to read" dropdown menu.
Also, as you can see from the above screenshot, there is no option for me to select the sheet I need.
It took me a long time to find out, but I need to click on another tab in this window, then come back to this window (XLS Reader Settings), and the drop down list will magically become available.
Please could you offer some advice if there is a better way to do this?