Icon

xlsx_​to_​csv_​converter

SO, 25.06.2019 Workflow reads all .xlsx files in the specified folder ("List Files") and saves them under the same name as .csv in the same folder reads the .xlsx file and saves it as .csv (happens for all files in the specified folder,one per loop iteration) - open the metanodes for more detailled information! first node converts the URL of each .xls file into different flow variables, i.a. nameof the folder (specified in "List Files") and the current file name - second nodespecifies location, file name and file type which is passed on to CSV Writer starts and ands the loop with one iteration for each file in the specified folder (everything else in this workflow is embedded in this loop) Shift + F7runs entire workflow select folder which contains .xlsx-files you would like to store as .csv Table Row ToVariable Loop Start Excel Reader (XLS) CSV Writer Loop End URL to FilePath (Variable) Create File Name Column Rename String Manipulation List Files Column Resorter SO, 25.06.2019 Workflow reads all .xlsx files in the specified folder ("List Files") and saves them under the same name as .csv in the same folder reads the .xlsx file and saves it as .csv (happens for all files in the specified folder,one per loop iteration) - open the metanodes for more detailled information! first node converts the URL of each .xls file into different flow variables, i.a. nameof the folder (specified in "List Files") and the current file name - second nodespecifies location, file name and file type which is passed on to CSV Writer starts and ands the loop with one iteration for each file in the specified folder (everything else in this workflow is embedded in this loop) Shift + F7runs entire workflow select folder which contains .xlsx-files you would like to store as .csv Table Row ToVariable Loop Start Excel Reader (XLS) CSV Writer Loop End URL to FilePath (Variable) Create File Name Column Rename String Manipulation List Files Column Resorter

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: soffenbach
Created at: 2019-06-25
On NodePit since: 2019-10-03
Last update: 2024-04-26
Created with KNIME version: v4.0.0

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

Try NodePit Runner!