Formating tables before writing them as excel

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.

Hello @89trunks,

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

Br,
Ivan

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.