Icon

kn_​forum_​excel_​read_​multiple_​files_​and_​sheets

Reading Multiple Excel files with different sheet names

This worklow reads in multiple excel files from a folder. It takes the location and the sheet as flow variables, which are used in the Excel Reader

modified from:
https://hub.knime.com/hanss/spaces/Public/latest/forum_flows/reading%20multiple%20excel%20with%20different%20sheet%20names

store some meta information about the files (you could do without) Read sheet namesfrom ExcelFileslist excel files fromsubfolder /data/Start OUTERLoop for Excel-FilesEnd INNERLoop for Excel-SheetsImport Sheetfrom Excel fileaddpath ofExcel Fileadd sheet nameNode 16Node 17Node 18Start INNERLoop for Excel-SheetsEnd OUTERLoop for Excel-FilesNode 21 Read Excel SheetNames (XLS) List Files Table Row ToVariable Loop Start Loop End Excel Reader (XLS) ConstantValue Column ConstantValue Column URL to File Path String to URI Extract URI Info Table Row ToVariable Loop Start Loop End Column Filter store some meta information about the files (you could do without) Read sheet namesfrom ExcelFileslist excel files fromsubfolder /data/Start OUTERLoop for Excel-FilesEnd INNERLoop for Excel-SheetsImport Sheetfrom Excel fileaddpath ofExcel Fileadd sheet nameNode 16Node 17Node 18Start INNERLoop for Excel-SheetsEnd OUTERLoop for Excel-FilesNode 21Read Excel SheetNames (XLS) List Files Table Row ToVariable Loop Start Loop End Excel Reader (XLS) ConstantValue Column ConstantValue Column URL to File Path String to URI Extract URI Info Table Row ToVariable Loop Start Loop End Column Filter

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: hans
Created at: 2019-10-25
On NodePit since: 2020-02-25
Last update: 2024-04-24
Created with KNIME version: v4.1.1
Tags: excelsheetsmultiplereader

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

Try NodePit Runner!