I thought that this is not so easy. I am really new, so I have to work through your answer mlauber71. but i will give you feedback! Thank you for your answers !
No to my knowledge. And don’t think it is easy as it sounds. You have to import data from Excel. Choose rows and columns you need and then write it into desired location.
There are two ways you can do this. One, uppend the Excel data and then put data to the form.
The other way is to copy the required rows and columns and then pasting them on to the form.
Hello Ivan, thx for your reply. The problem I have is not to get the data, but to paste it into an formatted Excel sheet without changing format (column and row width / height, grid lines, other formatting).
In Excel I would copy the data Array and special paste only the values, not the Format. At the moment, I need to do this manually after
Knime Processing, and I would have preferred not to touch the final Excel sheet. Perhaps there is a way, do this with a node where to include a VBA Macro?
yep, I understand. What you can try is to have formulas in your formatted sheet to existing sheet where you are going to write data from KNIME. This way once you write data sheet will be filled with new data and you should not lose your formatting.