Icon

kn_​example_​excel_​new_​node_​list_​sheets

This workflow demonstrates how to use the new Excel Reader and path variables and read Excel sheets

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



This workflow demonstrates how to use the new Excel Reader and path variables and read Excel sheetsThere 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 /data/ subfolderlocal_URIextract file name andextension fromPathlist XLSX files and give back URLsuse KNIME protocolextract meta informations fromfilesextract string frompath column"Location"read sheetvar_sheet_namevar_file_locationvar_export_table_path=> constructindividual file pathvar_export_table_path=> convert to newpath variableENDinnerloopENDouterloopread sheetvar_sheet_namevar_file_locationSTARTouterloopSTARTinnerloopwriteevery sheetto individualtable/result/folderSTARTouterloopSTARTinnerloopENDinnerloopcollectdataENDouterloopcollectdatawriteevery sheetto individualtable/result/folder GenerateExcel Files String to URI URL to File Path List Files/Folders Files/FoldersMeta Info Path to String Read ExcelSheet Names Excel Reader ConstantValue Column ConstantValue Column Java EditVariable (simple) String to Path(Variable) Variable Loop End Variable Loop End Excel Reader ConstantValue Column Read ExcelSheet Names ConstantValue Column Table Row ToVariable Loop Start Table Row ToVariable Loop Start Table Writer Table Row ToVariable Loop Start Table Row ToVariable Loop Start Loop End Loop End Table Writer This workflow demonstrates how to use the new Excel Reader and path variables and read Excel sheetsThere 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 /data/ subfolderlocal_URIextract file name andextension fromPathlist XLSX files and give back URLsuse KNIME protocolextract meta informations fromfilesextract string frompath column"Location"read sheetvar_sheet_namevar_file_locationvar_export_table_path=> constructindividual file pathvar_export_table_path=> convert to newpath variableENDinnerloopENDouterloopread sheetvar_sheet_namevar_file_locationSTARTouterloopSTARTinnerloopwriteevery sheetto individualtable/result/folderSTARTouterloopSTARTinnerloopENDinnerloopcollectdataENDouterloopcollectdatawriteevery sheetto individualtable/result/folder GenerateExcel Files String to URI URL to File Path List Files/Folders Files/FoldersMeta Info Path to String Read ExcelSheet Names Excel Reader ConstantValue Column ConstantValue Column Java EditVariable (simple) String to Path(Variable) Variable Loop End Variable Loop End Excel Reader ConstantValue Column Read ExcelSheet Names ConstantValue Column Table Row ToVariable Loop Start Table Row ToVariable Loop Start Table Writer Table Row ToVariable Loop Start Table Row ToVariable Loop Start Loop End Loop End Table Writer

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: m_lauber
Created at: 2020-12-29
On NodePit since: 2020-12-29
Last update: 2024-04-25
Created with KNIME version: v4.7.4

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!