Our application has the need to open workbooks that have been saved in the StrictOpenXml format. Calling the workbook's load method generates "Input string was not in a correct format." with the following stack dump. Any help would be appreciated.
Saving the file after removing the proprietary information causes it to be able to be read by the WinSpreadsheet control.
I believe the issue has to do with the fact that there are two forms of the Open XML format. The one that your control is able to read has 50 4B 03 04 14 00 06 00 as the first eight bytes. The one that Excel is able to open but your control is not has 50 4B 03 04 14 00 08 00 as the first eight bytes.
Further research seems to imply that the format your control is unable to open has different compression (see https://users.cs.jmu.edu/buchhofp/forensics/formats/pkzip.html for more details). The short of it is the format with 50 4B 03 04 14 00 06 00 as the header indicates that the compression method is "imploded" and the format with 50 4B 03 04 14 00 08 00 as the header uses the compression method "deflated."
Unfortunately, the files we are working with are produced by a third party and we do not have the ability to generate them. I will continue to investigate how we can "sanitize" a sample that I can send you but I hope what we have found out about the differences in the files will help you correct the exception.
You could do that. Or you could just e-mail it to Support@Infragistics.com and put "CAS-183105-W1V5L3" in the subject.
Might be a good idea to take any proprietary information out of the document, anyway, though. Maybe try creating the smallest possible file you can that still reproduces the problem.
Yes it opens in Excel. The data is not something I want to post in the forum. I can open a support ticket and pass along a sample spreadsheet there if that works.
Dana
Hi,
I assume the same files opens correctly in MS Excel?
If so, then can you provide me with a sample Excel document file I can use to test this and see the exception?