我正在尝试使用Python的win32com
API在Excel单元格中添加下拉菜单,但无法实现。
以下是我的代码:
from win32com.client import Dispatch
import os
import win32api
path = os.getcwd()
path1 = path + '\\myExcel.xlsx'
try:
xl = Dispatch("Excel.Application")
xl.Visible = 1 # fun to watch!
wb = xl.Workbooks.Open(Filename=path1)
ws = wb.Worksheets(1)
ws.Cells(1,1).Value = "GREEN"
ws.Cells(2,1).Value = "YELLOW"
ws.Cells(3,1).Value = "RED"
ws.Cells(4,1).Value = "WHITE"
ws.Cells(5,1).Value = "NOT SURE"
ws.Cells(6,1).Value = "["GREEN", "YELLOW", "RED", "WHITE", "NOT SURE"]" //I want drop down here
wb.Close(SaveChanges=True)
xl.Quit()
except Exception as e:
print(e)
ws.Cells(6,1).Value = "["GREEN", "YELLOW", "RED", "WHITE", "NOT SURE"]" //我想在这里添加下拉列表
- Saurabh AgrawalBoarGules
发布的链接。它正在执行相同的操作,但使用 VBA。 - Saurabh Agrawalws.Cells(6,1).Validation
而不是ws.Cells(6,1).Value
。请参考VBA示例进行设置。所有这类Excel文档都假定您正在使用VBA编程,因此您需要学会将解决方案转换为Python。 - BoarGules