Formating tables before writing them as excel

[89trunks]

Hi.

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.

[ipazin]

Hello @89trunks,

@89trunks

I want something that will allow me to make this change before writing excel.

Don’t think this is possible. But can you do this transformation looping over sheets?

Br,
Ivan