Multiple Excel File - Combine into separate tabs of one sheet

rparr009 · January 26, 2021, 4:10pm

Hi,

I am new and would like to be able to combine two separate excel sheets into one. I would like for the data to go into two separate tabs within the excel workbook.

Can I do this on Knime? If so how?

Thanks,

tobias.koetter · January 26, 2021, 4:30pm

Hi,
the Excel Writer node allows you to write multiple sheets (tabs) into a single Excel file. Either use the node several times with the same file name or add additional input ports to the node by clicking on the three dots (dynamic ports).
Bye
Tobias

rparr009 · January 26, 2021, 5:20pm

Thanks so much! You are a life saver!

system · February 2, 2021, 5:21pm

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.