Formating tables before writing them as excel


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?


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