Hi I was wondering if there is a not complex way (or any way) to write some data in knime as a xlsx (excel) with added column that contains drop down list. I would like to have excel file that has column where for each row I can choose a predefined option. For example: File is composed of 6 rows of some numbers. ID 123 245 678 999 1234 I would like to add column “extra info” with pre-defined options like: yes, no, not sure. Now when someone gets this excel when he clicks on second column for each row he will have option to choose. ID. extra info 123. No 245. No 678. Yes 999. Not sure 1234. Thanks

@89trunks I am not entirely sure what you mean. I checked your workflow and do not understand why you are using the loop. I have adapted the Python code and added some more comments for clarity. There is no need to loop thru the lines. You would just tell Python openpyxl that the validation rule you have defined should be applied to the area B2:B6. The number of lines is now created dynamically from the data and given to Python by Flow Variable - you could also just set the range by hand if you would know it. [image]

Write excel data file with column with drop down list.

KNIME Analytics Platform

mlauber71 June 30, 2020, 3:41pm 2

Yes that is possible with the help of Python and openpyxl

You could also check out this thread

–
Edit: KNIME and Excel — An Overview of What You Can Do | by Markus Lauber | Low Code for Data Science | Medium

6 Likes

Knime dropdown

How to read/write value in specify cell ?#excel

Can the Continental XLS Formatter format as Table?

Create a column with drop down menu / list