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
External resources
- more fun with URI, URL and File Paths - work with the new Path variable format to list and move/copy files
- [kn_meta] Import EXCEL - a meta workflow trying to answer questions about importing data from Excel files
- Inside KNIME Labs: A New Table Backend for Improved Performance
- even more fun with URI, URL and File Paths - work with the new Path variable format to list and move/copy files - using the latest KNIME version 4.6
- KNIME File Handling Guid
Used extensions & nodes
Created with KNIME Analytics Platform version 4.7.4 Note: Not all extensions may be displayed.
Legal
By using or downloading the workflow, you agree to our terms and conditions.