Integer thousand separator missing after export to Excel

KNIME Analytics Platform
#1

Hi all,
I would like to ask how to remain the thousand separator after export to Excel.
For example, this is how my data in KNIME before export to excel looks like
image

But after export to excel, it becomes. Need this format without having to manually change format in Excel. Could you please advise? Thank you!

image

#2

Try to use Continental nodes.
https://www.knime.com/community/continental-nodes-for-knime-xls-formatter

3 Likes
#3

Hi @JinnyLe,

Please review this link to learn how to show/hide thousands separator in Excel:

:blush:

1 Like
#4

Thanks @izaychik63: let me figure it out! This continental node was a challenge to me :smiley:

#5

@armingrudd: Thanks for your reply, Armin! Yes i am aware of it. But it means i need to open the excel file after it is created and edit? I would like to have it done without having to do so. As this created excel will be input of my other MS flow, so i would like to have something automated. But not sure i can do so with the above link?

#6

So as @izaychik63 has suggested you can use the Continental nodes to format cells.

Here is an example workflow to show thousand separator in an Excel file:
continental.knwf (29.6 KB)

:blush:

3 Likes
#7

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