Date and Time Output from AsDataSet()

Feb 2, 2011 at 8:20 AM

Hi,

I suggest to extend the ReadSheetRow(XlsxWorksheet sheets) method with nicer date and time output:

if (((DateTime)o).Year == 1899 && ((DateTime)o).Month == 12 && ((DateTime)o).Day == 30)
                                    o = ((DateTime)o).ToShortTimeString();
                                else
                                    o = ((DateTime)o).ToShortDateString();

What do you think?