{"id":2090,"date":"2026-05-28T16:25:02","date_gmt":"2026-05-28T08:25:02","guid":{"rendered":"https:\/\/xlwings.net\/blog\/?p=2090"},"modified":"2026-03-28T06:21:35","modified_gmt":"2026-03-28T06:21:35","slug":"how-to-use-applicationdisplaypasteoptions-in-the-xlwings-api-way","status":"publish","type":"post","link":"https:\/\/xlwings.net\/blog\/how-to-use-applicationdisplaypasteoptions-in-the-xlwings-api-way\/","title":{"rendered":"How to use Application.DisplayPasteOptions in the xlwings API way"},"content":{"rendered":"\n

The Application.DisplayPasteOptions property in Excel is a member of the Application object model that controls the visibility of the Paste Options button, which appears after a paste operation in the Excel user interface. This button provides users with a dropdown menu of context-specific paste formatting choices, such as keeping source formatting, matching destination formatting, or pasting values only. In xlwings, a powerful Python library for automating Excel, you can access and manipulate this property to either show or hide this button programmatically, allowing for a cleaner or more guided user experience during automation scripts. This is particularly useful when you want to suppress the button to prevent user distraction or ensure consistency in automated reports.<\/p>\n\n\n\n

Functionality<\/strong>
The primary function of DisplayPasteOptions is to toggle the display of the Paste Options button (also known as the “smart tag”) that appears after performing a paste action in Excel. When enabled, users can click this button to select various paste special options. When disabled, the button does not appear, which can streamline the interface during automated processes. In xlwings, you can get or set this property to control this behavior directly from your Python code.<\/p>\n\n\n\n

Syntax in xlwings<\/strong>
The property is accessed through the app<\/code> object, which represents the Excel Application. The syntax is straightforward:<\/p>\n\n\n\n

app.display_paste_options<\/code><\/pre>\n\n\n\n
This property is a Boolean value. You can read it to check the current state or assign a value to change it.<\/p>\n\n\n\n
    \n
  • Getting the property:<\/strong> current_state = app.display_paste_options<\/code><\/li>\n\n\n\n
  • Setting the property:<\/strong> app.display_paste_options = False<\/code> (to hide the button) or app.display_paste_options = True<\/code> (to show the button).<\/li>\n<\/ul>\n\n\n\n
    Parameters and Values<\/strong>
    The property does not take additional parameters. It simply accepts or returns a Boolean:<\/p>\n\n\n\n
      \n
    • True<\/code>: The Paste Options button will be displayed after a paste operation.<\/li>\n\n\n\n
    • False<\/code>: The Paste Options button will not be displayed.<\/li>\n<\/ul>\n\n\n\n
      Code Examples<\/strong>
      Here are practical examples using xlwings to work with the DisplayPasteOptions property:<\/p>\n\n\n\n
        \n
      1. Check the Current Setting:<\/strong><\/li>\n<\/ol>\n\n\n\n
        import xlwings as xw\n\n# Connect to the active Excel instance\napp = xw.apps.active\n\n# Get the current state of DisplayPasteOptions\nstatus = app.display_paste_options\nprint(f\"Paste Options button is currently displayed: {status}\")<\/code><\/pre>\n\n\n\n
          \n
        1. Hide the Paste Options Button:<\/strong><\/li>\n<\/ol>\n\n\n\n
          import xlwings as xw\n\n# Start a new Excel instance (or connect to active)\napp = xw.App(visible=True)\n\n# Hide the Paste Options button\napp.display_paste_options = False\n\n# Now perform some paste operation (e.g., via Range.copy and Range.paste)\nwb = app.books.add()\nsheet = wb.sheets[0]\nsheet.range('A1').value = 'Source Data'\nsheet.range('A1').copy(sheet.range('B1'))\n# After this paste, the Paste Options button will not appear\n\n# Keep Excel open for observation\ninput(\"Press Enter to close...\")\nwb.close()\napp.quit()<\/code><\/pre>\n\n\n\n
            \n
          1. Toggle Based on Condition:<\/strong><\/li>\n<\/ol>\n\n\n\n
            import xlwings as xw\n\napp = xw.apps.active\n\n# Suppose we want to hide the button only if a specific condition is met\nif some_condition: # Replace with your actual condition\n    app.display_paste_options = False\nelse:\n    app.display_paste_options = True\n\n# This allows dynamic control during a script's execution.<\/code><\/pre>\n\n\n\n
            <\/p>\n","protected":false},"excerpt":{"rendered":"
            The Application.DisplayPasteOptions property in Excel is a member of the Application object model th…<\/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-2090","post","type-post","status-publish","format-standard","hentry","category-xlwings-api-reference"],"_links":{"self":[{"href":"https:\/\/xlwings.net\/blog\/wp-json\/wp\/v2\/posts\/2090","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=2090"}],"version-history":[{"count":1,"href":"https:\/\/xlwings.net\/blog\/wp-json\/wp\/v2\/posts\/2090\/revisions"}],"predecessor-version":[{"id":3199,"href":"https:\/\/xlwings.net\/blog\/wp-json\/wp\/v2\/posts\/2090\/revisions\/3199"}],"wp:attachment":[{"href":"https:\/\/xlwings.net\/blog\/wp-json\/wp\/v2\/media?parent=2090"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/xlwings.net\/blog\/wp-json\/wp\/v2\/categories?post=2090"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/xlwings.net\/blog\/wp-json\/wp\/v2\/tags?post=2090"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}