output of excel writer

Hi everyone,

Just a simple string data, but this when I exported to excel (Excel Write node), it showed me this error

image

This is my raw data:
_x8fb7_9d7q

What is the problem here?

image

1 Like

@huynhduc ,

You can select the file format ‘XLS’. For your reference, I have attached an image.

Screenshot 2024-07-05 142125

Output:

Screenshot 2024-07-05 142257

2 Likes

Tks @tqAkshay95

Solved it, thank you a lots. But, is there any explanation for that?

1 Like

hey @huynhduc,

It seems like the text _x8fb7_9d7q is being interpreted as a Unicode character in KNIME when exporting to an Excel file. The specific sequence _x8fb7_ is being converted to the character .

Replace the underscore characters with another character before writing to Excel.

Regards,
Yogesh

2 Likes

Hi @yogesh_nawale ,

Thank you for your clarifying.

That is my raw data, it’s really sad to say that I can not change it. So that, I may need to use ‘xls’ exported :grin:

1 Like

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