How to use Range.Cut in the xlwings API way

The Range.Cut method in Excel’s object model is a powerful tool for moving a range of cells to a new location, effectively performing a cut-and-paste operation. In xlwings, this functionality is exposed through the cut method of a Range object. It is particularly useful when you need to relocate data while preserving cell formatting, formulas, or other properties, as it mimics the standard cut action in the Excel user interface.

Functionality
The primary purpose of the cut method is to move the contents and formatting of a specified range to a different range or destination. Unlike a simple copy, a cut operation typically removes the original data from its source location after pasting, though in xlwings, the behavior aligns with Excel’s programmatic actions where the source range remains until the cut is pasted elsewhere. This method is often used in data reorganization, report generation, or when integrating data from multiple sheets.

Syntax
In xlwings, the syntax for the cut method is straightforward:

Range.cut(destination=None)

• destination (optional): This parameter specifies the target range where the cut cells will be pasted. It can be a Range object or a string representing the cell address (e.g., "A1" or "Sheet2!B5"). If omitted, the cut range is placed on the clipboard, and you would need to use the paste method separately to complete the operation. In practice, providing a destination directly is more efficient for automation.

Example Usage
Here is a practical example demonstrating the use of cut in xlwings. Suppose you have an Excel workbook with data in a range that needs to be moved to another location within the same worksheet or a different one.

import xlwings as xw

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

# Define the source range to cut (e.g., cells A1 to C3)
source_range = sheet.range('A1:C3')

# Cut the source range and paste it to a new destination (e.g., starting at E1)
source_range.cut(destination=sheet.range('E1'))

# Alternatively, cut without specifying a destination and then paste
source_range.cut() # Cuts to clipboard
sheet.range('G1').paste() # Pastes from clipboard to G1

# For moving to another sheet, specify the sheet in the destination
other_sheet = wb.sheets['Sheet2']
source_range.cut(destination=other_sheet.range('A1'))