I use dhtmlxgrid to generate reports and offer the option to export to Excel using the asp.net tools provided.
I have a case where the output
I have some reports/grids that I can export without any problems, and when I export the remainder, I get the following error:
Excel found unreadable content in ‘grid.xlsx’. Do you want to recover the contents of this workbook? If you trust the source of this workbook, click Yes. (When you click yes, you then get the message “The workbook cannot be opened or repaired by Microsoft Excel because it is corrupt.”
I see one case where it seems that having parentheses around the content of some cells is causing trouble, because the data is very similar. Other cases I am not sure. Can someone enlighten me.
I am attaching the following:
-Screenshots of the good and bad data grid.
-Excel output of the good and bad data grid.
-Screenshots of the errors.
temp.zip (121 KB)