Programatically creating a XLS with a drop down cell in Python

Question

I am currently creating XLS files programatically using Python and the XLWT/XLRD libraries.

I've been able to fill the cells with values and insert simple formulas. My challenge is that I want to create a drop down for my users (http://office.microsoft.com/en-us/excel-help/create-or-remove-a-drop-down-list-HP005202215.aspx)

Yes, I can easily do this in EXCEL, but I need to have this process automated - I'm using Python and the XLWT/XLRD libraries - I'd rather stick with them, but I'll switch to something else if necessary (I'm in a Ubuntu Linux Server).

Answer 1

openpyxl also supports drop down cell in XLSX files via data validation: http://openpyxl.readthedocs.org/en/latest/validation.html