Hi,
I get a warning saying "we found a problem with some content. Do you want to recover ?" when i try to open an xlsx file generated using infragistics
Clicking on Yes gives a list of tables that were recovered.
Here is a sample of one of the tables -
<?xml version="1.0" encoding="UTF-8" standalone="true"?>
-<table xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main" headerRowCellStyle="Normal" headerRowDxfId="3" totalsRowShown="0" ref="A647:D686" displayName="someDisplayName" name="SomeName" id="2">
<autoFilter ref="A647:D686"/>
-<tableColumns count="4">
<tableColumn name=" " id="1" totalsRowCellStyle="Normal" totalsRowDxfId="4"/>
<tableColumn name=" 2" id="2" totalsRowCellStyle="Normal" totalsRowDxfId="5"/>
<tableColumn name=" 3" id="3"/>
<tableColumn name=" 4" id="4"/>
</tableColumns>
<tableStyleInfo name="Some Table" showColumnStripes="0" showRowStripes="1" showLastColumn="0" showFirstColumn="0"/>
</table>
This opens without any issues in xls. It would be really helpful if you could tell what the issue might be.
Thanks,
Vaishnavi
I was not able to understand which table exports and opens fine and which one gives error when trying to open after exporting. Also, do you try to export the WebDataGrid or igGrid ? Please provide more details and it would be best if you could provide a sample that exports a corrupted excel file. Then I will be bale to investigate and suggest accordingly.
Thank you for the reply. I have attached the corrupted xlsx file. Any help would be really appreciated.
I am using Infragistics 13.2.20132.2023
Thank you for the shared file. However I am not able to investigate the corrupted file itself, I would rather need a sample that exports a corrupted file. Please let me know if you will be able to provide one, otherwise I will need details on the scenario (the grid config, version of NetAdvantage used, the way WebExcelExporter is used, etc) so that I can try to replicate the issue on my side.
Looking forward to hearing from you.