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?
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?
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.
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?