Hello Infragistics-Support!
I've managed to perform a excel export from a XamDataGrid with the Exporter-Object.When I do this and export to the Excel 2007 file format and then open the file in Excel 2010 I get an error message.
It tells me it has found unreadable content.I've attached a screenshot of the error message.
When I say yes to restore the data excel seems to be able to restore it fully.At least I haven't found any wrong or false data.Excel has created a logfile, but there isn't much to see in that.
I don't get this when I export to the older format.
Do you have a solution for this?Is this "problem" known?
Hello Pawan,
Thank you for your post. I have been looking into your issue and I have not managed to reproduce it.
I am attaching a sample application(DataGridExportToExcel.zip) that I used for my tests.
Could you please tell me if the issue occurs with my application?
Looking forward to hearing from you.
Hello Yanko!
I just tested your example and get the same error message from Excel.
Could it be a language/culture issue?Do I have to set something to make sure, the Excel-Exporter uses the correct culture?
My Windows-System is set to German culture de-DE.
Hi Stefan,
Thank you for your reply. I created a virtual machine with Windows 7 x64 in German with installed Microsoft Office 2010 and tested my sample application. On my side the created Excel file could be opened successfully without any error message. I uploaded a descriptive video:
http://www.youtube.com/watch?v=7evgJuQi_N0&feature=youtu.be
Could you, please, give me some more details about your environment in order to be able to test it with the same settings as yours?
Ok here are the System-Infos:
I sure hope you can reproduce the problem, but I will let this be tested on other systems in our house, too.
Regards
Stefan Schmitt
The latest Infragistics WPF SR I'm using is Version: 13.2.20132.2036.
I just saw that there is a newer SR for the WPF.Has anything changed in the excel-export-framework?
BTW: I'm out of office from March 22nd to April 22nd 2014.
Hello Stefan,
Thank you for your reply. I checked the release notes for the latest Service Release(13.2.20132.2096) and it seems that there was a fixed issue that matches your description. You can find the release notes in the zip when download THE Service Release from our web site.
I managed to reproduce the reported error with your version of our assembly files. My suggestion is to update to the latest Service Release where this issue seems to be fixed.
Let me know, if you need any further assistance on this matter.
This was it!!!
After updating with the newest SR for the WPF-Module the exported excel files were created normally readable.
Hint:Behind our company firewall/gateway the automatic updating doesn't work.So I have too check manually for updates.
Best regards
Thank you for your feedback. I am glad that you have managed to resolve your issue.