Originally Posted 2 March 2017, 12:31 pm ESTI am using the C1.C1Excel.2 class to read in .xlsx files into an application. The dll is version 2.0.20171.248.
When loading a file saved as .xlsx from Google Docs it throws a System.FormatException.
Exception thrown: \'System.FormatException\' in mscorlib.dll
Additional information: Additional non-parsable characters are at the end of the string.
I am just calling the Load function feeding it the filename of the .xlsx file like in the example below.
xlsBook = new C1.C1Excel.C1XLBook();
I have tried all three CompatabilityMode options and that did not make a difference.
I have attached the an example file to this post that causes the error.
I will note that the file can be opened in Excel 2016. If I open it in Excel, click the Enable Editing button, and then click on the save icon to save over the file then I can load the new copy.
Your help with this issue would be appreciated.