Excel DataTable - problem with special characters

Help Studio
1

Hi,

I use Read Range to read all data from an Excel table into a DataTable. There are sentences in the table, but some sentences have special characters like the comma. As soon as special characters are in the text, they are not properly calculated in the DataTable. How do I get everything transferred to the DataTable, even with special characters?

grafik

Output DataTable

grafik

2

@Crusha you can give a try by checking Preserve Format check box.
image

3

problem still exists