code: def rows(array):
      
  
      if isinstance(array, (float, int)):
          rows = 1  # special case for A1:A1 type ranges which for some reason only return an int/float
      elif array is None:
          rows = 1  # some A1:A1 ranges return None (issue with ref cell)
      else:
          rows = len(array.values)
  
      return rows
docs: Function to find the number of rows in an array.
      Excel reference: https://support.office.com/en-ie/article/rows-function-b592593e-3fc2-47f2-bec1-bda493811597
  
      :param array: the array of which the rows should be counted.
      :return: the number of rows.