我设法创建了一个下拉列表。

from openpyxl import Workbook
from openpyxl.worksheet.datavalidation import DataValidation
wb = Workbook()
ws = wb.active
dv = DataValidation(type="list", formula1='"Fruit,Vegetable"')
ws.add_data_validation(dv)
dv.add(ws["A1"])
wb.save('test.xlsx')