Python xldate_as_tuple Examples

Example #1

 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.")

Example #2

File: xfcell.py Project: 8maki/Arelle

 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.")

Example #3

 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.")

Example #4

File: xfcell.py Project: 8maki/Arelle

 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.")