This workflow demonstrates how to use the new Excel Reader and path variables and read Excel sheets
There seems to be some questions about how to use the new Excel Reader together with the new path files. There are several ways to use them, namely the new Excel reader can just read all the sheets in a file or folder at once. But sometimes this is not what you want.
Please familiarize yourself with the new path concept since it is essential.
more fun with URI, URL and File Paths - work with the new Path variable format to list and move/copy files
https://hub.knime.com/mlauber71/spaces/Public/latest/kn_example_uri_url_path_more_fun_with?u=mlauber71
[kn_meta] Import EXCEL - a meta workflow trying to answer questions about importing data from Excel files
https://hub.knime.com/mlauber71/spaces/Public/latest/kn_example_excel_import_meta_workflow?u=mlauber71
To use this workflow in KNIME, download it from the below URL and open it in KNIME:
Download WorkflowDeploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.
Try NodePit Runner!