Read all sheets in a excel from Sharepoint in a loop

Hi all, I meet a question on read all sheets of a excel file from Sharepoint.
I know how to read all sheets of a local excel file in a loop and how to read one excel sheet from Sharepoint. But I fail to do the combination. My Knime flow is in picture. I set “download” node “target folder” to “temp_path” (also in the picture). After “Table row to variable”, I connect the node “read excel sheet name”. My setting is in picture. As a result, it still requires me to select file to read rather than get file path from variable. I want to eliminate the manual change of file path in this step. Can anybody help me? Thank you!



1 Like

I don’t see a reason why the node would ask for a location if it is configured via flow variable, so I’d consider this behavior as erroneous. However, it just needs some dummy path for initial configuration. Once execution dialog is closed and node is being executed, it will use the flow variable values.

1 Like

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