Error loading specific Excel file

Aspose.Cells Product Family
1

While using Aspose.Cells 7.7, an exception is thrown when attempting to open the attached file, however this file can be opened in Microsoft Excel.


var excel = new Aspose.Cells.Workbook(filePath);

Result Message: System.ArgumentOutOfRangeException : Year, Month, and Day parameters describe an un-representable DateTime.
Result StackTrace:
at System.DateTime.DateToTicks(Int32 year, Int32 month, Int32 day)
at •Ÿ\x8.\x14\x4\xE.\x18\xE(Byte[] , Int32 )
at •Ÿ\x8.\x14\x4\xE.\x2\x18\xF(\x16\x5\xE )
at •Ÿ\x8.\x14\x4\xE.\x1\x18\xF()
at •Ÿ\x8.\x14\x4\xE.Ÿ\x17\xF(MemoryStream )
at •Ÿ\x8.\x14\x4\xE.Read(\x12\x4\xE , Worksheet , \x1A\xE )
at •Ÿ\x8.Ž\x4\xE.\x5\x1D\xF()
at •Ÿ\x8.Ž\x4\xE.Read(WorksheetCollection , Worksheet , \x1A\xE , ˆ\x1A\xE )
at ‰\x1A\xE.\x1A\xE.\x2›\x10(ˆ\x1A\xE )
at ‰\x1A\xE.\x1A\xE.\x19š\x10(ˆ\x1A\xE )
at ‰\x1A\xE.\x1A\xE.\x1Fš\x10(ˆ\x1A\xE )
at ‰\x1A\xE.\x1A\xE.€š\x10(MemoryStream )
at ‰\x1A\xE.\x1A\xE.š\x10(\x1\x5 )
at ‰\x1A\xE.\x1A\xE.Read(\x1\x5 )
at Aspose.Cells.Workbook.\x1FŸ\x10(String , LoadOptions )
at Aspose.Cells.Workbook…ctor(String file)

2

Hi Barry,

Thanks for your posting and using Aspose.Cells.

We were able to replicate this exception using your source file with the latest version of Aspose.Cells. When the file is opened with Aspose.Cells API, it throws exception as you mentioned. We have logged this issue in our database. 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-42253.

3

Hi Barry,


Thank you for your patience.

We have fixed the issue logged earlier as CELLSNET-42253 in our bug tracking system. Attached to this post is the latest version of Aspose.Cells for .NET 7.7.0.3 that fixed the said problem. Please give the latest version a try at your end, and feel free to write back in case you face any difficulty.
4

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

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