Icon

20210526 Pikairos Can we write different columns in different sheet of Excel file

Q : I have a table who have 150 + Columns and I want to write it into the excel file but the condition is I want to write every column in the new sheet.

A : The solution for this kind of job would be to use a “Column List Loop Start” node in which you select the columns you need to save separately in every “sheet”. Inside the loop, you just need to save the column in a different sheet.

Dummy IRIS datafor the exampleHere I choseto select adifferent numerical columnevery time +a fix text columnjust for the exampleSave the current informationin a different sheetevery timeLoop overThis is just to close the loopNo table is expectedat the end of the loopCurrent iterationsheet NameFile Reader Column ListLoop Start Excel SheetAppender (XLS) Variable Loop End Java EditVariable (simple) Dummy IRIS datafor the exampleHere I choseto select adifferent numerical columnevery time +a fix text columnjust for the exampleSave the current informationin a different sheetevery timeLoop overThis is just to close the loopNo table is expectedat the end of the loopCurrent iterationsheet NameFile Reader Column ListLoop Start Excel SheetAppender (XLS) Variable Loop End Java EditVariable (simple)

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: Molina
Created at: 2021-05-26
On NodePit since: 2022-02-06
Last update: 2024-11-21
Created with KNIME version: v4.2.4

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!