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” )
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 ?
Best,
Joel
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.