def test_dates_column_dates(self):
normal_values = xls.normalize_dates([
xldate((2004, 6, 5), 0),
xldate((1984, 2, 23), 0),
xldate((1907, 12, 25), 0),
''], 0)
self.assertEquals(normal_values, (datetime.date, [datetime.date(2004, 06, 05), datetime.date(1984, 02, 23), datetime.date(1907, 12, 25), None]))
def test_dates_column_dates(self):
normal_values = xls.normalize_dates([
xldate((2004, 6, 5), 0),
xldate((1984, 2, 23), 0),
xldate((1907, 12, 25), 0),
''], 0)
self.assertEquals(normal_values, (datetime.date, [datetime.date(2004, 06, 05), datetime.date(1984, 02, 23), datetime.date(1907, 12, 25), None]))
def tests_dates_column_dates_and_datetimes(self):
normal_values = xls.normalize_dates([
xldate((2004, 6, 5), 0),
xldatetime((2001, 1, 1, 4, 5, 37), 0), ''
], 0)
self.assertEquals(normal_values, (datetime.datetime, [
datetime.datetime(2004, 6, 5, 0, 0, 0),
datetime.datetime(2001, 1, 1, 4, 5, 37), None
]))
def tests_dates_column_dates_and_datetimes(self):
normal_values = xls.normalize_dates([
xldate((2004, 6, 5), 0),
xldatetime((2001, 1, 1, 4, 5, 37), 0),
''], 0)
self.assertEquals(normal_values, (datetime.datetime, [datetime.datetime(2004, 6, 5, 0, 0, 0), datetime.datetime(2001, 1, 1, 4, 5, 37), None]))
def test_dates_column_dates_and_times(self):
self.assertRaises(XLSDataError, xls.normalize_dates, [
xldate((2004, 6, 5), 0),
xltime((4, 5, 37)),
''], 0)
def test_dates_column_dates_and_times(self):
self.assertRaises(XLSDataError, xls.normalize_dates,
[xldate((2004, 6, 5), 0),
xltime((4, 5, 37)), ''], 0)
