{"id":2187,"date":"2026-07-16T07:15:28","date_gmt":"2026-07-15T23:15:28","guid":{"rendered":"https:\/\/xlwings.net\/blog\/?p=2187"},"modified":"2026-03-28T10:15:02","modified_gmt":"2026-03-28T10:15:02","slug":"how-to-use-applicationshowquickanalysis-in-the-xlwings-api-way","status":"publish","type":"post","link":"https:\/\/xlwings.net\/blog\/how-to-use-applicationshowquickanalysis-in-the-xlwings-api-way\/","title":{"rendered":"How to use Application.ShowQuickAnalysis in the xlwings API way"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">The <code>ShowQuickAnalysis<\/code> 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.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The syntax for accessing this property in xlwings is straightforward. It is called on the application object, which represents the Excel instance. Since <code>ShowQuickAnalysis<\/code> is a property, it can be set to <code>True<\/code> or <code>False<\/code> to control the visibility of the Quick Analysis tooltip. Typically, it is set to <code>True<\/code> 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.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Here is a basic code example demonstrating its usage:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>import xlwings as xw\n\n# Connect to the active Excel instance or start a new one\napp = xw.apps.active\n\n# Open a workbook or use the active one\nwb = app.books.active\n\n# Select a specific range, e.g., A1:D10, which contains data for analysis\nws = wb.sheets.active\nws.range('A1:D10').select()\n\n# Show the Quick Analysis tooltip for the selected range\napp.ShowQuickAnalysis = True<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n","protected":false},"excerpt":{"rendered":"<p>The `ShowQuickAnalysis` property of the Application object in Excel, accessible via the xlwings libr&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[25],"tags":[],"class_list":["post-2187","post","type-post","status-publish","format-standard","hentry","category-xlwings-api-reference"],"_links":{"self":[{"href":"https:\/\/xlwings.net\/blog\/wp-json\/wp\/v2\/posts\/2187","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/xlwings.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/xlwings.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/xlwings.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/xlwings.net\/blog\/wp-json\/wp\/v2\/comments?post=2187"}],"version-history":[{"count":1,"href":"https:\/\/xlwings.net\/blog\/wp-json\/wp\/v2\/posts\/2187\/revisions"}],"predecessor-version":[{"id":3344,"href":"https:\/\/xlwings.net\/blog\/wp-json\/wp\/v2\/posts\/2187\/revisions\/3344"}],"wp:attachment":[{"href":"https:\/\/xlwings.net\/blog\/wp-json\/wp\/v2\/media?parent=2187"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/xlwings.net\/blog\/wp-json\/wp\/v2\/categories?post=2187"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/xlwings.net\/blog\/wp-json\/wp\/v2\/tags?post=2187"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}