Xls writer multiple worksheet support


I have had a growing number of colleagues asking about multiple worksheet support in writing xls files, which would be a good idea.

are there any plans to implement this? It could be implemented by having a column to select in the XLS writer node which contains a number of categories/classes, the node uses these different classes as different worksheets. So the rows are sectioned to the appropriate worksheet.

as an aside, can you include an auto launch option in the xls writer node, so once the file is written, excel loads up.


I would agree with this suggestion - I've often needed it too.  Also, a reader node which will read multiple (all?) sheets - perhaps creating a sheet name column in the output?

Multiseet support for Excellspreadsheets has been added in KNIME Desktop version 2.8