I have created a workflow that looks like as shown in the image attached. What i find strange is that it works for 1 excel file but when I use the same workflow for another file then it runs the loop as it is supposed to but always gives the output from first worksheet only and doesnt show any records from 2nd worksheet onwards. Please help me find out what needs to be changed.
Welcome to the Community.
I can only suppose that the ‘issue’ comes from using ‘overwrite’ option instead of ‘append’ in the Excel Reader configuration. I would suggest to play with configuration and see what happens.
The other thing is the KNIME version you use. What works correctly up to version 5.2.5 may work incorrectly in version 5.3. The KNIME internal ticket for this bug is AP-22911.
Happy KNIMEing,
Kaz
1 Like
@Dhammapal_Avhad you can use the KNIME python integration and openpyxl to append data to existing sheets
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.