System.FormatException when reading xlsx file

Aspose.Cells Product Family
1

When we try to open the attached file using Aspose.Cells, a System.FormatException is thrown with the following message: “Input string was not in a correct format.” The stack trace is attached in a text file, so as to save the Unicode obfuscated method names.





In my testing, simply opening the file in Excel and saving it seems to fix the problem, but is there a way to open it successfully with Aspose without having to do that?





Thanks,


Michael Whalen

2

Hi Michael,

Thanks for your posting and using Aspose.Cells.

We were able to observe the exception after opening your source file with the following code using the latest version: Aspose.Cells
for .NET v8.1.0.3.

We have logged this issue in our database for investigation. We will look into it and fix this issue. Once, the issue is resolved or we have some other update for you, we will let you know asap.

This issue has been logged as CELLSNET-42782.

C#


string filePath = @“F:\Shak-Data-RW\Downloads\QA+LAB.xlsx”;

Workbook workbook = new Workbook(filePath);

3

The issues you have found earlier (filed as CELLSNET-42782) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by Aspose Notifier.
4

Wow - thanks for the fast turnaround! Works great.

– Michael Whalen

5

Hi Michael Whalen,

Thanks for your feedback and using Aspose.Cells.

It is good to know that your issue is resolved with the latest fix. Let us know if you encounter any other issue, we will be glad to look into it and help you further.