openpyxl复制下拉菜单

使用openpyxl库复制下拉菜单的方法如下：

import openpyxl

def copy_dropdown(source_book, source_sheet, source_cell, destination_book, destination_sheet, destination_cell):
    # 打开源工作簿和目标工作簿
    source_wb = openpyxl.load_workbook(source_book)
    destination_wb = openpyxl.load_workbook(destination_book)
    
    # 获取源单元格的数据验证规则
    source_ws = source_wb[source_sheet]
    source_validation = source_ws.data_validations.dataValidation
    source_validation_formula = None
    for validation in source_validation:
        if validation.sqref == source_cell:
            source_validation_formula = validation.formula1
            break
    
    # 若找到源单元格的数据验证规则，则在目标单元格应用该规则
    if source_validation_formula:
        destination_ws = destination_wb[destination_sheet]
        destination_validation = openpyxl.worksheet.datavalidation.DataValidation(
            type="list",
            formula1=source_validation_formula,
            showDropDown=True
        )
        destination_ws.add_data_validation(destination_validation)
        destination_validation.add(destination_ws[destination_cell])

    # 保存目标工作簿
    destination_wb.save(destination_book)

对于你的问题，假设你想将源工作簿中的`Sheet1`的`A1`单元格中的下拉菜单复制到目标工作簿的`Sheet2`的`B2`单元格中，你可以使用以下代码：

copy_dropdown("source.xlsx", "Sheet1", "A1", "destination.xlsx", "Sheet2", "B2")