There is a new KNIME forum. You can still browse and read content from our old forum but if you want to create new posts or join ongoing discussions, please visit our new KNIME forum: https://forum.knime.com

how can Read list of xls;xlsx files and add them to my data Report node

Member for

2 years 6 months Mokrani

Dear all,

I would like if it possible to read multiple xls files or xlsx files then read each URL file and sent to Data report Node.

For example:

I have List of xls files:

C:\Users\mok\folder\file1.xls

C:\Users\mok\folder\file2.xls

C:\Users\mok\folder\file3.xls

I want to get the first table of the first file and sent to data report then iterate automatically to the second xls file to generate new data in Data report Node.

Note:  I don't want to merge all the files in 1 data table.

I used the node List  file->Table Row TO variable Loop Start->excel Reader: Location variable read from URL -> LoopEnd Node but it gives the last as result the last table 

Please find attached screenshot of my workflow.

I'm looking for your suggestion.

Thank you.

Bests. 

 

Comments
Fri, 03/02/2018 - 03:29

Member for

10 years 2 months

Iris

Hi Mokrani,

this is not possible with a loop. You would need one Data to Report node for each File you read.

Best, Iris 

Fri, 03/02/2018 - 05:53

Member for

2 years 6 months

Mokrani

Hi Iris,

In this case, when i have two file as an example-> when I will run the Data report node it will combine all the inputs file rows in my report with different information from different files.

 i want a sperate report from different files XLS.

 

Bests