How to split or separate Multiple sheets/tabs inside a excel workbook

How to split or separate Multiple sheets/tabs inside a excel workbook

Hi @Jithin1893,
Have you try the Read Excel sheet names node (Read Excel Sheet Names – KNIME Community Hub) and parse with a table row to variable loop start ?

Best,
Joel

3 Likes

Hi @Jithin1893 , there is an example of what @JPollet suggests in the KNIME examples on the hub here:

(ignore “XML” in the description. It should say “Excel” :wink: )

3 Likes

hello am able to read the sheet name and i added a table row to variable loop whtn when adding excel reader the file is not able get selected

Hello,
Have you select the sheet with the loop variable ?
image

Best,
Joel

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