Create a dropdown list and reading its values

Question

I promise this will be my last question (at least today! thanks for the patience). I want to create a drop down list and then read the valuee into an Excel chart. So my question is: can I create a dropdown list directly with xlwings? Or if it cannot be done with xlwings, can I do it with xlswriter while modifying an active xlwings workbook?

Thanks!!!

该提问来源于开源项目：xlwings/xlwings

Answer 1

xlsxwriter can only write new workbooks and hence you can't work on an open workbook. Anything you can do with VBA you should be able to do with xlwings, at least using the .xl_... attribute. If you have some VBA code that does what you want it's easier to help.