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?
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.
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.