excel read files

[caolivsan]

I’m trying to make a workflow to read many excel files in a folder and convert in only one
file with corresponding sheets using loop and variables control.

[mlauber71]

@caolivsan welcome to the KNIME forum. You can take a look at this example

Consolidate Multiple Excel Files into one -

@Bewaji2 it could look something like this: [image] The structure of the Files is like this. Folder1/File4.xlsx is deliberately missing checking the comparison: [image] Only the matching Excel Files will be imported and the be written to a new Excel file. You can adapt the elements and re-combine them. More examples with Excel here: Import EXCEL - a meta workflow trying to answer questions about importing data from Excel files – KNIME Community Hub

If you want to do more with Excel I can offer this article.

KNIME and Excel — An Overview of What You Can Do

[caolivsan]

Thanks. Could you make availabe this workflow?So i can understand the nodes settings.

[mlauber71]

@caolivsan the workflow is at the end of the first link

Combine Excel Files from two Folders and export to a new Excel File -...

Also you can use these examples

Import EXCEL - a meta workflow trying to answer questions about importing...

[caolivsan]

Thank you very much.

[caolivsan]

I did the workflow but I couldn’t put the file names in the spreadsheets, just the interaction number. Can you take a look at the workflow?
Merge multiple Excel with sheet names.knwf (54.1 KB)