Read Excel sheets with looping

Hello KNIMERs,

I need some help with the looping.

I want to use a similar loop as the for…next cycle.

I want to read data from an excel file, in the first loop from the sheet “1” in the second loop from the sheet “2” … in the 18th loop from the sheet “18”.

Making table manipulations.

After that writing the data in the n the first loop on the sheet “1” in the second loop on the sheet “2” … in the 18th loop on the sheet “18”.

Thank you for the answers in advance!

Best Regards,
Roland

Hi
have you checked the sample excel reader flows on the KNIME hub?
br

1 Like

Hello @rolandnemeth,

here is workflow that can help with reading multiple sheets from same Excel file. For your use case node missing is Excel Writer (which seems to replace Excel Sheet Appender functionality from version 4.3.) prior to loop end.

Probably what @Daniel_Weikert had on mind :slight_smile:

Br,
Ivan

1 Like

Hello,

thanks for the support!

Meantime I solved with an R Snippet node, the code is the next.

library(“readxl”)
MACHCTMATRIX <- c(read_excel(knime.flow.in[[“URI”]],
sheet=knime.flow.in[[“loop_value”]]))
knime.out <- MACHCTMATRIX

The sheetnames are numbers, I get the content of the appropriate sheet from the excel file based on the actual loop value, and catch the file via URI.

2 Likes

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