We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Getting Unpresentable date time after opening XLSB document

Hi Aspose Support Team,

We are getting an “Unpresentable data time” error while opening the XLSB document. Please review this as provide us with the necessary fix.

Un-representable DateTime.zip (54.8 KB)

@harshshah903,

I am able to reproduce the issue as you mentioned by opening the file via Aspose.Cells APIs. I found an exception “Year, Month, and Day parameters describe an un-representable DateTime” on reading the XSLB file via Aspose.Cells.
e.g.
Sample code:

Workbook workbook = new Workbook("e:\\test2\\CP Sample 3.xlsb");

I have logged a ticket with an id “CELLSNET-50095” for your issue. We will look into it and try to figure it out soon.

Once we have an update on it, we will let you know here.

@harshshah903,

This is to inform you that your issue has been resolved. We will provide you the fixed version within the next few days after performing QA and incorporating other enhancements and fixes.

@harshshah903
Please try the latest fix 21.12.3.
Aspose.Cells21.12.3 For .Net2_AuthenticodeSigned.Zip (5.6 MB)
Aspose.Cells21.12.3 For .Net4.0.Zip (5.6 MB)
Aspose.Cells21.12.3 For .NetStandard20.Zip (5.6 MB)

The issues you have found earlier (filed as CELLSNET-50095) have been fixed in this update. This message was posted using Bugs notification tool by simon.zhao