def get_address(name: str, xl: w32 = None) -> str: """ Address from a named range Parameters ---------- name: str Excel Address xl: {None, xl_app} Returns ------- range address as str """ return xl.Evaluate(name).GetAddress()
def check_name_present(name: str, xl: w32 = None) -> bool: """ Checks if the named range is present in the excel. Parameters ---------- name: str Excel named range xl: {None or xl_app} Returns ------- bool indicating the presence of the named range """ return False if isinstance(xl.Evaluate(name), int) else True
def get_value(name: str, xl: w32 = None): """ Returns the value of a excel named range Parameters ---------- name: str Excel named range xl: {None, xl_app} Raises ------ NameMissingInExcel Returns ------- value of the range in a tuple """ try: return xl.Evaluate(name).Value except AttributeError: raise NameMissingInExcel(name)