This project has moved. For the latest updates, please go here.

net datetimes and LoadFromDataTable

May 26, 2011 at 11:52 AM

Hello,

Are .net datetimes support when using the method "LoadFromDataTable"? They are displayed as number with the current version 2.8.0.2

Kind Regars, Tom


Coordinator
May 26, 2011 at 4:57 PM

Yes, but you need to set the numberformat to a date format (something like worksheet.Cells["A1:A100"].Style.NumberFormat.Format="yyyy/mm/dd")

Mar 28, 2013 at 5:01 PM
But why do not use by default application's or system current regional settings for date? Though it's not cover all cases but cover good part of cases and better than some incomprehensible number.