Excel DataTable - problem with special characters


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?


Output DataTable


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

problem still exists