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: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Problem in exporting the spreadsheet control(visual studio C#)

Thread ID:





117895 Jan 6,2015 12:08 PM UTC Feb 19,2016 10:51 AM UTC WPF 11
Tags: SpreadsheetControl(Classic)
Kalaivani B
Asked On January 6, 2015 12:08 PM UTC

Hi ,

Iam using the spreadsheet control of syncfusion in my UI . When i copy any cell data into another cell and tried to export the data into excel .

It got exported to excel but when i try to open the exported excel i cant able to open the file results in Error "Excel found unreadable content in 'test.xlsx'.Do you want to recover the contents of this workbook?If you trust the source of this workbook,click  yes.

When i click on YES then the Excel is of Empty .

Please clarify .


Neelakandan Kannan [Syncfusion]
Replied On January 6, 2015 12:08 PM UTC

Hi Kalai,

Thank you for your interest in Syncfusion products.

We regret to let you know that we have not provided Spreadsheet control in Windows Forms platform. But you have mentioned in your previous update that you have used  Spreadsheet control in your UI. So that we could not able to clearly understand your query. Please provide us details regarding followings,

1.Platform of your application

2.Control(Spreadsheet or GridControl) which is used in your application since we have not provided Spreadsheet control for Windows Forms platform.

Moreover we have already provided the Dashboard sample regarding export grid data to excel. So that please make use of below sample,


<Installation Location>\Syncfusion\EssentialStudio\<Product Version>\Windows\Grid.Windows\Samples\Exporting\Exporting Demo

Please let me know if you have any concerns.



Kalaivani B
Replied On January 6, 2015 12:08 PM UTC

Iam using Visual studio 2012 C# application .
 Syncfusion.spreadsheet.wpf  reference

Kalaivani B
Replied On January 6, 2015 12:08 PM UTC

Additional information for your clarification

I can able to export the spreadsheet data into excel perfectly .

Problem occurs when exporting the data after performing  copy paste any cell data to another cell  on spreadsheet .

Is any junk values are added into the cell of spreadsheet when i paste the data ?So that the excel getting unreadable data ?

Hope you got my problem .

Kanimozhi Bharathi [Syncfusion]
Replied On January 7, 2015 04:49 PM UTC

Hi Kalaivani,

Apologize for the delay caused.

 We have analyzed and tested the reported issue with our sample, but we are unable to reproduce the reported issue. Could you please revert us with the modified sample based on your application along with the replication procedure? This would be helpful for us to serve you a better solution.

Please find the sample and video link below,

Sample Link: http://www.syncfusion.com/downloads/support/directtrac/117895/demo-1604255138.zip

Video Link: http://www.syncfusion.com/downloads/support/directtrac/117895/exprt-588770493.zip

Please let me know if you have any concerns.


Kanimozhi B

Kalaivani B
Replied On January 8, 2015 06:25 AM UTC

Thanks for your reply .

I have no clue why its behaving differently in my application .
I have few combo entries in my spreadsheet .but it got exported well when i didnt perform any copy paste operation .

i cant able to run your demo code as it showing mainWindow.xaml.cs file missing and RibbonWindow doesn't exist in namespace error .

Kalaivani B
Replied On January 8, 2015 08:21 AM UTC

iam adding ComboBox in the Spreadsheet at run time using the below code

control.SPlusSpreadsheetControl.AddComboBoxToCell(2, 3, new[] { string.Empty })

 public void AddComboBoxToCell(int Rowindex, int ColumnIndex, string[] listOfValues)
            IRange range = WorkSheet[Rowindex, ColumnIndex];
            IDataValidation validation = range.DataValidation;
            validation.ListOfValues = listOfValues;
            validation.PromptBoxText = "Data Validation list";
            validation.IsPromptBoxVisible = true;
            validation.ShowPromptBox = true;

After combo got added to spreadsheet if i copy paste anything in the spreadsheet and do Export to excel then iam getting the exported excel with unreadable content error .

Kalaivani B
Replied On January 12, 2015 06:29 AM UTC

Please reply ASAP

Kanimozhi Bharathi [Syncfusion]
Replied On January 12, 2015 12:36 PM UTC

Hi Kalaivani,

Apologize for the delay

XlsIO team  are able to reproduce the issue and have logged defect report regarding this. A support incident to track the status of this defect has been created under your account. Please log on to our support website to check for further updates


Please let me know if you have any questions.


Kanimozhi B

Replied On February 18, 2016 09:54 AM UTC

 I have the same issue. Did you get any answer for it

Kalaivani B
Replied On February 18, 2016 10:09 AM UTC

Hello Arun,

Yes I got patch dll with the issue fixed .


Kanimozhi Bharathi [Syncfusion]
Replied On February 19, 2016 10:51 AM UTC

Hi Arun,

The “Unreadable content Error issue while exporting” has been fixed and included in  our latest release (Version and is available for download under the following link.

Kanimozhi B


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.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

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