OverflowException exception on opening workbook

Aspose.Cells Product Family
1

Hello,


An exception when opening the excel file attached:

System.OverflowException: Value was either too large or too small for an
Int32.
at System.Number.ParseInt32(String s, NumberStyles style,
NumberFormatInfo info)
at ”…‚(XmlElement , , Boolean )

            var fileName = @“Portfolio Investments Collection Tempate_7.xlsx”;

var workbook = new AC.Workbook(fileName);


Removing formulas (or unhiding the column) from column A on ‘GAP VI Investments’ sheet helps.
Thanks,
Leo
2

Hi Leo,

Thanks for your posting and using Aspose.Cells.

Please download and use the latest version: Aspose.Cells
for .NET v8.2.0.2 it does not throw any exception while loading this file.

We tested it with the following code and the Excel file was loaded fine.

C#


string filePath = @“F:\Portfolio+Investments+Collection+Tempate_7.xlsx”;


var workbook = new Workbook(filePath);


3

Thanks Shakeel! Yes, it works in 8.2.0.2.

4

Hi,


Good to know that it figures out your issue now. Feel free to contact us any time if you need further help or have some other issue or queries, we will be happy to assist you soon.

Thank you.