Writing to various sheets of an Excel workbook

KNIME Analytics Platform
1

Hello, 

I have an analysis with multiple branches. At the end of each branch, I want to write the resulting tables (Pivot table) to one sheet of an Excel file. 

- Excel file should be created if it does not exist yet.

- Every branch of analysis is expected to write exclusively one sheet of the file (to a separate sheet).

- The sheet should be created if it does not exist yet. If it exists, then it should be overriden.

How can achieve this?

Thank you.

2

Hi,

did you already see our example workflow about this? We published it last week. You can find it here:

knime://EXAMPLES/01_Data_Access/01_Common_Type_Files/09_Multiple_Sheet_in_one_Excel_File 

 

Best wishes, Iris