{"id":2191,"date":"2026-07-18T07:55:15","date_gmt":"2026-07-17T23:55:15","guid":{"rendered":"https:\/\/xlwings.net\/blog\/?p=2191"},"modified":"2026-03-28T10:17:45","modified_gmt":"2026-03-28T10:17:45","slug":"how-to-use-applicationsmartartcolors-in-the-xlwings-api-way","status":"publish","type":"post","link":"https:\/\/xlwings.net\/blog\/how-to-use-applicationsmartartcolors-in-the-xlwings-api-way\/","title":{"rendered":"How to use Application.SmartArtColors in the xlwings API way"},"content":{"rendered":"\n

The SmartArtColors<\/strong> member of the Application<\/strong> object in Excel provides programmatic access to the collection of color styles available for SmartArt graphics. This collection is essentially the set of color themes you see in the “Change Colors” gallery when working with a SmartArt graphic in the Excel interface. Through xlwings, you can retrieve this collection to apply predefined, coordinated color schemes to SmartArt objects, enhancing visual consistency and appeal without manually setting individual colors. This is particularly useful for automating report generation or ensuring corporate branding across multiple charts.<\/p>\n\n\n\n

Syntax and Parameters<\/strong><\/p>\n\n\n\n

In xlwings, you access this property via the Application object. The property returns a SmartArtColors<\/strong> object, which is a collection of SmartArtColor<\/strong> objects. Each SmartArtColor<\/strong> object represents a specific color style (e.g., “Colorful – Accent Colors”, “Gradient Loop – Accent 1”).<\/p>\n\n\n\n

The basic xlwings API call format is:<\/p>\n\n\n\n

app.smart_art_colors<\/code><\/pre>\n\n\n\n
    \n
  • Return Value:<\/strong> An xlwings object representing the SmartArtColors<\/code> collection. There are no parameters for this property call.<\/li>\n<\/ul>\n\n\n\n
    To work with individual color styles, you typically iterate through the collection or access items by their index (which corresponds to the order in the Excel gallery, usually starting at 1). A common subsequent step is to apply a color style to a specific SmartArt graphic by setting the SmartArt graphic’s ColorStyle<\/code> property to the desired SmartArtColor<\/strong> object.<\/p>\n\n\n\n
    Code Example<\/strong><\/p>\n\n\n\n
    The following xlwings code demonstrates how to list available SmartArt color styles and apply one to an existing SmartArt graphic on the active worksheet.<\/p>\n\n\n\n
    import xlwings as xw\n\n# Connect to the active Excel instance and application\napp = xw.apps.active\n\n# Access the SmartArtColors collection\ncolor_collection = app.smart_art_colors\n\n# Example 1: List the names of available color styles\nprint(\"Available SmartArt Color Styles:\")\n# The collection is 1-indexed. We use .count to get the number of items.\nfor i in range(1, color_collection.count + 1):\n    color_style = color_collection(i) # Access by index\n    print(f\" {i}: {color_style.name}\")\n\n# Example 2: Apply a specific color style to a SmartArt graphic\n# Assuming the first shape on the active sheet is a SmartArt graphic\nwb = app.books.active\nsheet = wb.sheets.active\n\n# Target the first shape\ntarget_shape = sheet.shapes[0]\n\n# Check if the shape is a SmartArt graphic (requires platform-specific API caution)\n# In practice, you might ensure this shape is SmartArt via its properties.\n# Apply the third color style in the collection (e.g., \"Gradient Range - Accent 1\")\n# First, get the desired SmartArtColor object\ndesired_color_style = color_collection(3)\n\n# Apply it by setting the SmartArt graphic's ColorStyle property.\n# Note: Direct property access might require using the .api property for full OM features.\ntarget_shape.api.ColorStyle = desired_color_style\n\nprint(f\"Applied '{desired_color_style.name}' to the SmartArt graphic.\")<\/code><\/pre>\n\n\n\n
    <\/p>\n","protected":false},"excerpt":{"rendered":"
    The **SmartArtColors** member of the **Application** object in Excel provides programmatic access to…<\/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-2191","post","type-post","status-publish","format-standard","hentry","category-xlwings-api-reference"],"_links":{"self":[{"href":"https:\/\/xlwings.net\/blog\/wp-json\/wp\/v2\/posts\/2191","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=2191"}],"version-history":[{"count":2,"href":"https:\/\/xlwings.net\/blog\/wp-json\/wp\/v2\/posts\/2191\/revisions"}],"predecessor-version":[{"id":3351,"href":"https:\/\/xlwings.net\/blog\/wp-json\/wp\/v2\/posts\/2191\/revisions\/3351"}],"wp:attachment":[{"href":"https:\/\/xlwings.net\/blog\/wp-json\/wp\/v2\/media?parent=2191"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/xlwings.net\/blog\/wp-json\/wp\/v2\/categories?post=2191"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/xlwings.net\/blog\/wp-json\/wp\/v2\/tags?post=2191"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}