We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on : Nov 16th 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Error "Unreadable Content" while opening excel file

Thread ID:

Created:

Updated:

Platform:

Replies:

129247 Mar 7,2017 08:42 AM UTC Mar 8,2017 03:10 PM UTC ASP.NET Web Forms 2
loading
Tags: XlsIO
gaurav singh
Asked On March 7, 2017 08:42 AM UTC

Hi,

I am creating excel file from datatable using  worksheet.ImportDataTable(dtExport, True, 1, 1, True) method. But we have some non printable character (ASCII value is 6,10,20,21,22,23,24,25 and 26 etc) in our database. Excel file is created successfully but when trying to open it giving error "Unreadable content" and after clicking yes giving illegal xml character.  But when we are directly  copy content to excel file and save then open ms excel not giving any error. 

I am attaching demo project having excel file in temp folder.  We are using 6.402.0.15 version of syncfusion dll.

So is there any way to fix this issue.

Please help me out 

Thanks in advance.



Attachment: ExcelDemo_cfa93051.zip

Sridhar Sukumar [Syncfusion]
Replied On March 8, 2017 11:58 AM UTC

Hi Gaurav, 
 
Thank you for contacting Syncfusion support. 
 
We are able to reproduce the issue and it has been fixed in our latest version 15.1. We strongly recommend you to upgrade to our latest version (15.1.0.37) of Essential Studio which has more improvements and enhancements which is available for download under the following link. 
 
 
Please let us know if you have any concern. 
 
Regards, 
Sridhar S. 


gaurav singh
Replied On March 8, 2017 03:10 PM UTC

Hi Sridhar,

Thanks for your response. 

I just want to ask  Is there another way to handle this issue without upgrading syncfusion dlls?

Thanks. 

CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

;