def time(self): """ Returns a datetime.time object if cell type is XL_CELL_DATE else raises a TypeError. """ if self.is_datetime: date = xldate_as_tuple(self.value, self.book.datemode) return datetime.time(date[3], date[4], date[5]) else: raise TypeError("Cell is not a XL_CELL_DATE.")
def datetime(self): """ Returns a datetime.datetime object if cell type is XL_CELL_DATE else raises a TypeError, and raises ValueError if the the cell has not date value (only time value is present). """ if self.is_datetime: if self.has_date: date = xldate_as_tuple(self.value, self.book.datemode) return datetime.datetime(*date) else: raise ValueError("Cell has no date value.") else: raise TypeError("Cell is not a XL_CELL_DATE.")