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

Free Support Forum - aspose.com

Exception with message "Year- Month- and Day parameters describe an un-representable DateTime. "

Conversion of one of the file failed while converting excel file to PDF. We are using Aspose.Cells(Ver. 7.0.2.0). Following is the exception we got. Please provide fix asap.


Code snippet:

Workbook workbook = new Workbook(sourceFilePath);
workbook.Save(destinationFilePath, Aspose.Cells.SaveFormat.Pdf);

Exception:

Timestamp: 1/18/2012 5:16:54 AM
Message: HandlingInstanceID: a27e3dff-6d23-4fb6-97d3-f3e452f63b42

An exception of type ‘System.ArgumentOutOfRangeException’ occurred and was caught.
2012-01-18 00:16:54Z
System.ArgumentOutOfRangeException, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
Year, Month, and Day parameters describe an un-representable DateTime.
mscorlib in file: C:\WINDOWS\TEMP\IntraLinks\1ad64054-82eb-443d-8061-6c571ab27aeb.xls



System.Collections.ListDictionaryInternal
Int64 DateToTicks(Int32, Int32, Int32)
at System.DateTime.DateToTicks(Int32 year, Int32 month, Int32 day)
at x484486ddc8e52eef.x54ec3bed6813979e.x6bfe39ecf058bc42(Byte[] x4a3f0a05c02f235f, Int32 x374ea4fe62468d0f)
at x484486ddc8e52eef.x54ec3bed6813979e.x60e9035b7dc15e1f()
at x484486ddc8e52eef.x54ec3bed6813979e.x705a490c88a1f91c()
at x484486ddc8e52eef.x54ec3bed6813979e.x58ff2d8b8cf7f5c8(MemoryStream x6e0053ba4d6bb1c4)
at x484486ddc8e52eef.x54ec3bed6813979e.x06b0e25aa6ad68a9(xfc686d5bce097028 x1f31bf6ca58166a1, Worksheet x99ecbc7e3ae0e29b, x8b6071c5dcbbf539 x3b41448adea64309)
at x484486ddc8e52eef.xd6c068b9dc379245.x35db41d5b3184c65()
at x484486ddc8e52eef.xd6c068b9dc379245.x06b0e25aa6ad68a9(WorksheetCollection x6d7b41a5fb54bb38, Worksheet x99ecbc7e3ae0e29b, x8b6071c5dcbbf539 xe134235b3526fa75, x508b33aea0611cd1 xcf18e5243f8d5fd3)
at x2e38ab1759381034.x8b6071c5dcbbf539.xbddc206c7dafc24d(x508b33aea0611cd1 xcf18e5243f8d5fd3)
at x2e38ab1759381034.x8b6071c5dcbbf539.x2a9806f9bb2936af(x508b33aea0611cd1 xcf18e5243f8d5fd3)
at x2e38ab1759381034.x8b6071c5dcbbf539.x6b024d3b2b8f9765(MemoryStream xcf18e5243f8d5fd3)
at x2e38ab1759381034.x8b6071c5dcbbf539.x6f3d999f7a817f2d(xd8c3135513b9115b x84378c276c4cd7e2)
at Aspose.Cells.Workbook.Open(Stream stream, FileFormatType type)
at Aspose.Cells.Workbook.Open(String fileName)
at Intralinks.Common.Utilities.AsposeConverter.ConvertXlsToPdf(String sourceFilePath, String destinationFilePath) in c:\ilbuilds\pdfconv\build_trunk\CommonUtilities\AsposeConverter.cs:line 71
at Intralinks.Common.Utilities.CommonUtilities.ConvertOfficeDocsToPDF(String sourceFile, String destinationFolder, Boolean useOriginalFileName) in c:\ilbuilds\pdfconv\build_trunk\CommonUtilities\CommonUtilities.cs:line 1385









Category: Logging Exception
Priority: 1
EventId: 100
Severity: Error
Title:Enterprise Library Exception Handling
Machine: WDPDPF01
Application Domain: ILPDFConversionService.exe
Process Id: 1504
Process Name: C:\PDFConvService\WOODDALE.pdfconv\instance3\Release\ILPDFConversionService.exe
Win32 Thread Id: 3452
Thread Name:
Extended Properties: Product Version - 3.0.24944.0

Hi,


Please download and try our latest version/fix: Aspose.Cells for .NET v 7.1.1.1

If you still find the issue, kindly attach your Excel file here, we will check your issue soon.

Thanks,