Read Excel Sheet Names - can't feed variable

[EllenPaige]

I am using the Read Excel Sheet Names node to loop through and read all tabs of an excel. However, the excel file I want to read the sheet names from is dynamic and I can’t figure out how to feed in a variable into the file reading section of the node. Other excel nodes seem to have this capability.

Thanks!

[dnaki]

Hi.
In the configuration dialog of the Read Excel Sheet Names node, click on the “Flow Variables” tab.
Then use XLS_LOCATION drop-down menu to select the variable containing the path of the Excel file.
This is the general way to assign variables to configuration dialog options.

As you apparently noticed, sometimes there’s a convenient button beside the control in the dialog that makes this a bit easier (see for example screenshot for Excel Reader, below), but not with the Read Excel Sheet Names node.