How to use Range.ShowErrors in the xlwings API way

The ShowErrors property of the Range object in Excel is a useful tool for data validation and error checking within a worksheet. When working with formulas, Excel can display various error values such as #DIV/0!, #N/A, #NAME?, #NULL!, #NUM!, #REF!, and #VALUE!. The ShowErrors property allows you to draw attention to these errors by applying a specific border style around cells that contain them. This visual indicator can help users quickly identify and correct problematic cells in large datasets. In xlwings, you can access and manipulate this property through the api property of a Range object, which provides direct access to the underlying Excel object model.

Syntax in xlwings:
range.api.ShowErrors

• This property is both readable and writable. It returns or sets a Boolean value (True or False).
• When set to True, Excel draws a border around cells in the specified range that contain formula errors. When False, the border is removed.
• The property applies to a Range object, which can be a single cell, a range of cells, or an entire worksheet area.

Parameters:
The ShowErrors property does not take additional parameters. It is a simple Boolean property that toggles the error-indicating border on or off for the given range.

Example Usage in xlwings:

1. Enabling Error Borders:
   To highlight formula errors in a specific range, such as A1:D10, you can set the ShowErrors property to True. This will draw borders around any cells within that range that contain errors.

import xlwings as xw

# Connect to the active workbook and sheet
wb = xw.books.active
ws = wb.sheets['Sheet1']

# Define the range
target_range = ws.range('A1:D10')

# Enable error borders for the range
target_range.api.ShowErrors = True

2. Checking Current Status:
   You can also read the current status of the ShowErrors property to determine if error borders are already applied to a range.

# Check if error borders are enabled for the range
status = target_range.api.ShowErrors
print(f"ShowErrors enabled: {status}") # Output: True or False

3. Disabling Error Borders:
   To remove the error borders from a range, simply set the property to False.

# Disable error borders for the range
target_range.api.ShowErrors = False

4. Applying to Entire Worksheet:
   If you want to apply error highlighting to an entire worksheet, you can use the UsedRange property to get all cells with data and then set ShowErrors.

# Apply error borders to all used cells in the worksheet
ws.used_range.api.ShowErrors = True