This project has moved and is read-only. For the latest updates, please go here.

net datetimes and LoadFromDataTable

May 26, 2011 at 12:52 PM


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

Kind Regars, Tom

May 26, 2011 at 5: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 6: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.