Function absolute_range_name

gspread/utils.py:713–739

Return an absolutized path of a range. >>> absolute_range_name("Sheet1", "A1:B1") "'Sheet1'!A1:B1" >>> absolute_range_name("Sheet1", "A1") "'Sheet1'!A1" >>> absolute_range_name("Sheet1") "'Sheet1'" >>> absolute_range_name("Sheet'1") "'Sheet''1'" >>> absolute_

(sheet_name: str, range_name: Optional[str] = None)

def absolute_range_name(sheet_name: str, range_name: Optional[str] = None) -> str:
    """Return an absolutized path of a range.

    >>> absolute_range_name("Sheet1", "A1:B1")
    "'Sheet1'!A1:B1"

    >>> absolute_range_name("Sheet1", "A1")
    "'Sheet1'!A1"

    >>> absolute_range_name("Sheet1")
    "'Sheet1'"

    >>> absolute_range_name("Sheet'1")
    "'Sheet''1'"

    >>> absolute_range_name("Sheet''1")
    "'Sheet''''1'"

    >>> absolute_range_name("''sheet12''", "A1:B2")
    "'''''sheet12'''''!A1:B2"
    """
    sheet_name = "'{}'".format(sheet_name.replace("'", "''"))

    if range_name:
        return "{}!{}".format(sheet_name, range_name)
    else:
        return sheet_name


def is_scalar(x: Any) -> bool: