Appending to Excel XLSM File

[tstolle94]

Hi,

problem is that the Excel Sheet Appender node does not exist anymore now and appending to a xlsm with the normal Excel writer is not possible. Is there a workaround that I do not see for this?

Thanks!

BR,

Tim

[ScottF]

Hi @tstolle94 -

I moved your post to a separate topic since the other thread is 5+ years old.

I did a little digging here and unfortunately you’re right, it seems the current version of the Excel Writer won’t append to XLSM files. We have a ticket to improve this (AP-16957) and I will add a +1 on it from you.

In the meantime, you could try accessing the Excel Sheet Appender in a very roundabout way.

While you can’t drag-and-drop the Excel Sheet Appender from the Community Hub (because it has been deprecated), what you can do is load a work flow that includes it, and copy the node out of that workflow, like this one:

SQLite - multiple joins with KNIME – mlauber71

Does that help you? As workaround I know it’s quite convoluted. Sorry about that.

[mlauber71]

@tstolle94 concerning Excel XLSM I tried this some time ago. Though you might proceed with caution:

How to export at xlsm file

well there is a way … You could use the R package openxlsx to add a sheet to an existing Excel file with a macro. It is not super straightforward since you first have to check if the sheet is there, the delete it, save the file, open it again and then add a worksheet, then populate it and then write the whole thing again. Cf. this entry. So numerous things could go wrong, but it is possible. Not sure how large the files can get. And I think the R package openxlsx is a little bit picky if you …

use R's openxlsx to add a worksheet to an existing Excel file with a macro...