Icon

kn_​forum_​42783_​excel_​multiple_​files_​into_​sheets

Collect data from 4 differet Excel files and put it into sheets of a single file

Collect data from 4 differet Excel files and put it into sheets of a single file

write the imported Excel Files into one singel file just create the dummy data excel files Collect data from 4 differet Excel files and put it into sheets of a single file createDummy DatacreateExcel Filescreate4 dummyexcel filesENDCreate Excel Filescreate theExcel File NameslistExcel Filesfrom/data/ folderthat start with the Name"Cluster*"read theexcel filesextractFile NamesSTARTto writeto single excelFilemy_target_file.xlsxSheet Name controlled byVariableEND Data Generator Group Loop Start Excel Writer Variable Loop End Create File/FolderVariables List Files/Folders Excel Reader Path to URI URL to File Path Table Row ToVariable Loop Start Excel Writer Variable Loop End write the imported Excel Files into one singel file just create the dummy data excel files Collect data from 4 differet Excel files and put it into sheets of a single file createDummy DatacreateExcel Filescreate4 dummyexcel filesENDCreate Excel Filescreate theExcel File NameslistExcel Filesfrom/data/ folderthat start with the Name"Cluster*"read theexcel filesextractFile NamesSTARTto writeto single excelFilemy_target_file.xlsxSheet Name controlled byVariableENDData Generator Group Loop Start Excel Writer Variable Loop End Create File/FolderVariables List Files/Folders Excel Reader Path to URI URL to File Path Table Row ToVariable Loop Start Excel Writer Variable Loop End

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: 2022-05-10
On NodePit since: 2022-05-11
Last update: 2024-04-26
Created with KNIME version: v4.5.2
Tags: excelimportsheetlistfiles

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

Try NodePit Runner!