Let’s assume that I would like to write 3 tables into excel. They would be writtten into seperate sheets. So I would have one file excel with 3 sheet. The tables differ in size and number of columns.
I am looking for the way to change some columns format so number in Excel would be sepereted by Space (format # ##0) in that my number in knime 11122344 would be 11 122 344.
I was trying using continental nodes but they allow me to change only excel that already exist.
So I have to do this transformation for each sheet seperate.
I want something that will allow me to make this change before writing excel.