code: def _cell_to_python(cell):
      
      data_type, value = cell.data_type, cell.value
  
      if type(cell) is EmptyCell:
          return None
      elif data_type == "f" and value == "=TRUE()":
          return True
      elif data_type == "f" and value == "=FALSE()":
          return False
  
      elif cell.number_format.lower() == "yyyy-mm-dd":
          return str(value).split(" 00:00:00")[0]
      elif cell.number_format.lower() == "yyyy-mm-dd hh:mm:ss":
          return str(value).split(".")[0]
  
      elif cell.number_format.endswith("%") and isinstance(value, Number):
          value = Decimal(str(value))
          return "{:%}".format(value)
  
      elif value is None:
          return ""
      else:
          return value
docs: Convert a PyOpenXL's `Cell` object to the corresponding Python object.