DateTime FormatException

[Martin Dusek]

Hi,

this code produces "System.FormatException: Input string was not in a correct format." exception when last line of the code is reached.

            ExcelEngine excelEngine = new ExcelEngine();
            IApplication application = excelEngine.Excel;
            application.DefaultVersion = ExcelVersion.Excel2013;
            IWorkbook workbook = application.Workbooks.Create(1);
            IWorksheet worksheet = workbook.Worksheets[0];

            worksheet.Range[1, 1].DateTime = new DateTime(2016, 12, 20, 23, 25, 20);

            System.IO.MemoryStream stream = new System.IO.MemoryStream();
            workbook.SaveAs(stream);

Why and how to fix it?

[Sridhar Sukumar]

Hi Martin, 

 

Thank you for contacting Syncfusion support. 

 

We are unable to reproduce the issue from our side. We suspect that this issue might be raised based on the machine culture. So, kindly share us the details about your machine culture which will be helpful for us to investigate further on this.