Node "Write to Excel Template" if the table has more rows

KNIME Analytics Platform
1

Hello, i think the node is brilliant because the EXCEL formatting is retained. However, i have encountered a problem. If the number of rows to be written is smaller than those contained in the EXCEL table, the surplus rows are not changed. What are the possibilities? Is there a node to delete the complete contents of the table before writing? Or read the EXCEL table, determine the last row and last column, fill the area with nil/null and write the file?

I am grateful for any good ideas

Translated with DeepL Translate: The world's most accurate translator (free version)

2

I prefer to create a new document from the template file each time, then reference the table dynamically as a table or dynamic range. However there is an advanced setting that will erase the current data which is helpful in some scenarios.

1 Like