xls formatting 'logic'
Dear Community
I started with KNIME this May. I would like to format the excel saved with “excel writer”, but I am not able to apply the concept since there is no change realized in the excel I intend to format.
Can anyone help me on this?
Coding/situation:
A sorter node contains the final data table before writing the data with “Excel Writer”.
From this sorter node I connect an “XLS Control Table Generator”, in the configuration I select ‘write comun header to first row’ and apply/OK.
From this I connect an “XLS Cell formatter” and input in the tag selection the tag “WE Total”; for data type and format I would like to have 1000 separator without decimals => apply/OK.
From this I connect an “XLS Formatter (apply)” and do a ‘red connection’ to “Excel Writer”.
Running all the nodes I can not realize any change in the column “WE Total”…
What am I doing wrong…?
Thanks a lot and best regards
Martin