I am facing a crash while loading an Excel file using following code:
The crash appears only for xlsx file; not for xls.
I am receiving the excel file from my client. And strangely the crash does not happen with same aforesaid code if I do the following steps with the file before loading it with code:
Thanks and Regards
And here is the file I am trying to upload.
I have been investigating into the behavior you are seeing, and I have found an internally logged issue that has since been fixed that appears to be the same issue as this one. The exception you are seeing was being caused by some restrictions that were present on the Excel 2003 formats that no longer existed as of the Excel 2007 formats. We were abiding by these restrictions until we had more support for Excel 2007 (.xlsx) formats, but there were still some restrictions that hadn’t been lifted that resulted in this erroneous behavior, and that was the reason for the issue being logged.
The internally logged issue was fixed in late version 2013.2, and unfortunately there did not exist a known workaround to this behavior outside of upgrading to a version later than 2013.2. As such, and being that version 2011.1 is no longer supported or maintained, the best thing I can recommend to you in this case is to upgrade the version of Infragistics for Windows Forms that you are targeting to a more recent version. If you would like to Trial our latest version 2019.2, you can get this from our website, here: https://www.infragistics.com/.
Please let me know if you have any other questions or concerns on this matter.