Write multiple excel files

Hi, I have created a workflow which selects CSV file as input and modifies column names & values. After doing this it saves the data as an excel workbook. I want to run this workflow for 100 files and create 100 excel workbooks with a variable name present in data of each CSV. Please suggest how can I do same.

Hi,

In short … start with file list node, use the location of files as variable to start variable loop to read csv files one by one process them (inside the loop) From the data create the file name, transform it to variable and use it for writing excel files (always inside the loop).

4 Likes

@Ayazins welcome to the KNIME forum

Maybe you can take some inspiration from these entries. If you have further questions you might want to construct a minimal example demonstrating a question.

Excel Sheets iterate

Excel types of loops

Read and annotate Excel files

3 Likes

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.