How to use Range.NavigateArrow in the xlwings API way

The NavigateArrow method in Excel’s Range object is a powerful feature for tracing cell dependencies, particularly useful in auditing formulas by following precedent or dependent arrows. In xlwings, this method is accessible through the api property, which provides direct access to the underlying Excel object model. It allows you to programmatically navigate through tracer arrows that indicate relationships between cells, such as which cells affect the active cell (precedents) or which cells are affected by it (dependents). This functionality is essential for debugging complex spreadsheets, as it helps visualize and inspect formula linkages.

Syntax in xlwings:
The xlwings API call follows the Excel object model closely. The syntax is:

range_object.api.NavigateArrow(TowardPrecedent, ArrowNumber, LinkNumber)

• TowardPrecedent (Required, Boolean): Specifies the direction of navigation. Set to True to move toward precedents (cells that affect the active cell), or False to move toward dependents (cells affected by the active cell).
• ArrowNumber (Required, Integer): Indicates which tracer arrow to follow, typically starting from 1 for the first arrow. In cases with multiple arrows, this parameter selects a specific one.
• LinkNumber (Optional, Variant): Used if the arrow is an external reference arrow; it specifies which external link to follow. If not applicable, this can be omitted or set to 1.

Example Usage:
Suppose you have an Excel workbook where cell B10 contains a formula referencing cells A1:A5 and C10. You can use xlwings to trace precedents and navigate through arrows. First, ensure xlwings is installed and connected to Excel:

import xlwings as xw
# Connect to the active workbook and sheet
wb = xw.books.active
ws = wb.sheets.active
# Select a range, e.g., cell B10
target_range = ws.range("B10")
# Navigate toward precedents using the first tracer arrow
try:
    # This moves the selection to the precedent cells along the arrow
    result_range = target_range.api.NavigateArrow(True, 1)
    print("Navigated to precedent:", result_range.Address)
except Exception as e:
    print("Error navigating arrow:", e)