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)