Openpyxl：如何粘贴到活动单元格及解决当前版本活动单元格设置失效问题

Hey there, I get it—dealing with outdated Openpyxl docs or answers can be super frustrating, especially when the API shifts between versions. Let’s break down your two questions and fix the issues you’re running into:

1. How to Set the Active Cell in Current Openpyxl Versions #

The older approach you referenced (using ws.sheet_view.selection[0]) no longer works because Openpyxl restructured how sheet views are accessed in versions 3.0+. Here’s the correct, up-to-date way to set the active cell:

import openpyxl

wb = openpyxl.Workbook()
ws = wb.active

# Access the first sheet view's selection object
sheet_view = ws.views.sheetViews[0]
selection = sheet_view.selection[0]

# Set the active cell to B4
selection.activeCell = 'B4'
# Match the selected range to the active cell (mimics Excel's native behavior)
selection.sqref = 'B4'

# Save to verify changes
wb.save('active_cell_demo.xlsx')

A quick heads-up: Sometimes Excel might override the active cell when you open the file if it remembers a previous view state. Close all Excel instances before opening your saved file to see the correct active cell.

2. Pasting Content to the Active Cell #

Openpyxl doesn’t have a built-in "paste to active cell" function like Excel’s UI—this is because it’s designed to manipulate spreadsheet files directly, not simulate user interactions. Instead, you’ll need to:

• Grab the active cell’s coordinate
• Write your content directly to that cell (or expand to a range if pasting multiple cells)

Example: Pasting a Single Value #

# Use the active cell we set earlier
active_cell = selection.activeCell
ws[active_cell] = "Pasted content!"

Example: Pasting a Range of Cells #

If you’re copying a range (e.g., A1:A3) and want to paste starting at the active cell:

from openpyxl.utils import coordinate_from_string, column_index_from_string

# Define your source range to copy
source_range = ws['A1:A3']
target_start = selection.activeCell

# Convert target coordinate to row/column indices
target_col, target_row = coordinate_from_string(target_start)
target_col_idx = column_index_from_string(target_col)

# Copy values from source to target range
for row_offset, source_row in enumerate(source_range, start=0):
    for col_offset, cell in enumerate(source_row, start=0):
        target_cell = ws.cell(
            row=target_row + row_offset,
            column=target_col_idx + col_offset
        )
        target_cell.value = cell.value

Why the Old Answer Failed #

Openpyxl made a breaking change to its sheet view API structure—what was once ws.sheet_view is now nested under ws.views.sheetViews. This shift is why older code snippets no longer work. If you’re still having issues, double-check your Openpyxl version (run pip show openpyxl to confirm) and ensure it’s 3.0 or later.

内容的提问来源于stack exchange，提问作者flywire