Creating an Excel File with DataValidation drop down List



I am quite new to KNIME and I am exploring if there are available capabilities to embed a datavalidation drop down list in an excel cell. I will be extracting directly from the db the list for drop down.Any help would be great!

It looks as if you could do this with the Python modules openpyxl or xlsxwriter in a Python script node. Both of these libraries appear to support pandas DataFrames (the form in which your Python code will receive the data table from KNIME) so it might be quite straightforward.