When I export some grids to excel ".xlsx" format some of the excel files tell me that they are corrupted using v19.2 excel exporter
Example grid:
And after I click "Yes" the file will be repaired.
The log file
<?xml version="1.0" encoding="UTF-8" standalone="yes"?> <recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main"> <logFileName>error061240_01.xml</logFileName> <summary>Errors were detected in file 'D:\HubCapacity.xlsx'</summary> <repairedRecords summary="Following is a list of repairs:"> <repairedRecord>Repaired Records: Format from /xl/styles.xml part (Styles)</repairedRecord> </repairedRecords> </recoveryLog>
Hello Jason,
Thank you for contacting. I did little research and find same log is been discussed here. But also this is very old post , I am not expecting that we have the same culture specific separator issue again here.
So may I know which grid feature you enabled in the grid ? Does any special architecture of the column header causing this? Try to narrow down the issue and update us.
The best way for us to assist you is if you provide a small isolated sample that we can run with the same xlsx file and use for debugging locally.
Looking forward to hear you back.
Sincerely,Divya Jain
I have tried to upload a sample that shows how the error is cause. Can I email it to you?
Hello,
You can delete the bin/package folder and zip the sample and then try to attach again. If you still not able to attach it then email to support@infragistics.com.
I don't see anything under Support Activity in My Account.
Thank you for your sample application. I am able to reproduce the issue you described. When i click the export button first i was getting error "we found a problem with some content in test.xlsx. Do you wants us to recover as much as we can ..." and then the repair window .i debug the code and find issue is from 'excelExporter_InitializeColumn' when you set ExcelFormatStr.
which looks like a bug to me. I am going to create a private case 'CAS-208545-L6Z7Z2' and attach the bug.
You can access this private case from infragistics account 'Support Activity' page.
Let me know if you have any question.
-Divya Jain
I have to back track, it does give an error on xls as well but not a corruption error. Says that data could be lost.
ExportExcelErrorTest.zipI have narrowed it down to the InitializeColumn event for the excel export where the column format is assigned to the excel format.
This works if I am exporting to a .xls file format but gives a file corrupted if trying to export to .xlsx.