How to use Application.ShowQuickAnalysis in the xlwings API way

The ShowQuickAnalysis property of the Application object in Excel, accessible via the xlwings library in Python, provides a convenient way to programmatically trigger the Quick Analysis feature. This feature, when invoked, offers users a context-sensitive menu with various tools for data analysis and visualization, such as conditional formatting, charts, totals, tables, and sparklines. It is particularly useful for enhancing data presentation and gaining insights directly from a selected range without navigating through multiple ribbon tabs. In xlwings, this functionality is exposed as a property of the application instance, allowing for seamless integration into automated Excel workflows.

The syntax for accessing this property in xlwings is straightforward. It is called on the application object, which represents the Excel instance. Since ShowQuickAnalysis is a property, it can be set to True or False to control the visibility of the Quick Analysis tooltip. Typically, it is set to True to display the tooltip for a specific range. The property does not take any arguments directly, but its effect is applied to the currently selected range in the active workbook. To use it effectively, you should first select the desired range of cells before setting the property.

Here is a basic code example demonstrating its usage:

import xlwings as xw

# Connect to the active Excel instance or start a new one
app = xw.apps.active

# Open a workbook or use the active one
wb = app.books.active

# Select a specific range, e.g., A1:D10, which contains data for analysis
ws = wb.sheets.active
ws.range('A1:D10').select()

# Show the Quick Analysis tooltip for the selected range
app.ShowQuickAnalysis = True