XLS Sheet Appender Node


I am trying to append data to an existing excel file.  The excel file only has one sheet, but I would like to add the new data to a second sheet.  Is there anyway I can "create" an empty second sheet in KNIME, because at the moment the XLS Sheet appender node can only append to existing sheets in a excel file and cannot create a new sheet.

I hope there is a quick and simple answer.


Hi Macca, 

The XLS Sheet Appender does not need the sheet to exist before you excute the node.  Most likely you just need to specify the sheet name using a flow variable.  

See attached for an example.  

Best regards,