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.