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

Automatic formatting of dates

May 8, 2012 at 3:50 PM

This is a great project.  A request is to add automatic formatting of dates and datetimes to the LoadFriom... methods.  That would at least set Style.Numberformat.Format and do a column AutoFit().  I think that would simplifiy writing dates/datetimes.

Sep 16, 2012 at 2:39 PM
Edited Sep 16, 2012 at 2:41 PM

+1 Vote!

I'm using code below currently:

worksheet.Column(1).Style.Numberformat.Format = CultureInfo.CurrentCulture.DateTimeFormat.ShortDatePattern;      worksheet.Column(1).AutoFit();