Kendo UI Grid Excel Export Unprintable Characters

Vote count:

0

I'm using the Kendo UI Grid to display data imported from various 3rd party sources. When I use the Export To Excel functionality of the grid I am getting an error from Excel, it would appear that the grid is not formatting / handling non-printable characters correctly.

Error from Excel: Removed Part: /xl/sharedStrings.xml part with XML error. (Strings) Illegal xml character. Line 2, column 55298. Removed Records: Cell information from /xl/worksheets/sheet1.xml part

The actual character at the column is:

Is there any way that I can get the grid to string non-printable characters on export, or would I be better trying to write a pre-parser when the data is loaded.

asked 1 min ago

ciantrius

55

Kendo UI Grid Excel Export Unprintable Characters