Write to different sheets in a work book

KNIME Analytics Platform
1

At the moment I have 1 input file that create 4 reports (4 separate excel files), writing to the Excel Writer (XLS) Node.

What node do I use to write to 1 Excel Writer and choose the Sheet?

2

Hi Earl,

Simply use the Excel Sheet Appender node. First create an xls file with the Excel Writer for the first report and then point the Excel Sheet Appender nodes to the same Excel file. If you want to skip entering the same Excel file name and location in each of them, you can use a flow variable to pass the filename/location from one to another.

Cheers,
Medzi

3 Likes