Replacement of Excel Sheet Appender

I’m using KNIME version 4.3 and found that the Excel Sheet Appender node is gone. Is there a replacement node for Excel Sheet Appender? Or should I use the new Excel Writer to append sheets and set the sheet name as flow variable?

Appreciate any help on this.

Thanks!

Xenia

1 Like

Excel Writer got an append option. Also, interesting question if you want to overwrite existing page or add new one with advanced name 01 so on.

In the sheet name section you can select whether you want to fail or overwrite existing sheets in case you append to an existing excel file. Soon you’ll also see an append option there to add rows to an existing sheet.

What are your thoughts / feedback on this and yes we decided to remove the sheet appender and replace it by the append option in the writer.

Best
Mark

I currently can only asses the decision by itself. It sounds destructive to some extent. To compensate this, a migration tool for Excel nodes needs to be provided.

1 Like

What do you mean by destructive?

I mean that excluding nodes without equivalent alternative is destructive. I still suffer from Database looping exclusion as it was 10 times faster than alternative.

@xeniaay - were you able to resolve this? In order to append with the new Excel Writer, here is a sample of the setup. It has the equivalent function as the old Sheet Appender.

Cheers!

1 Like

@supersharp Yes I realize that there’s the Write options available for me to choose “append”. BTW, it seems that the “open after execution” is missing in the new Excel Writer. Is it correct?

Thanks
Xenia

Yes that is the case:

But maybe there is a way how to do it anyway:

Dear All,
it seems that another important feature is missing as well. I cannot load the file name as a variable (e.g. to use an input file from the workflow and attach a sheet). This option is greyed, but still works with the depreceated excel sheet appender. Could the latter not be still maintained, given that automatic execution of excel file is a very important function. If you create a number of evalution sheets and write them into an excel file for reporting, it is very convenient to open this excel file immediately an browse through the different sheets.
Stefan

1 Like

you will have to use the new Path variables.

2 Likes