XLS Sheet Appender Node

KNIME Analytics Platform
1

Hi

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.

Stephen

2

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,

Aaron