Insert empty rows between already existing rows in an Excel

[chaithuj]

I have a knime Table with 15 rows.
I want to update an excel and insert these 15 rows between Row 5 and Row 6

How can I do it.

Regards
Chaitanya

[HansS]

hi @chaithuj

For this you can use the Add Empty Rows node, see
insert_15_additional_rows.knwf (22.4 KB)

gr. Hans

[chaithuj]

Thank a lot HansS, it worked perfect.
We had issues when trying write it back to the Excel, but we were able to figure it out.

Reagrds
Chaitanya