Hello, I’m trying to code a Drop down list in Excel through a Python Script node 1=>1, when I run it, it says “Execution succesful” but it doesn’t do anything on the excel file. Here is the script: import xlsxwriter import openpyxl workbook = xlsxwriter.Workbook(‘Excel file.xlsx’) worksheet = workbook.add_worksheet() txt = ‘ACTION’ worksheet.write(‘B1’, txt) worksheet.data_validation(‘B2’, {‘validate’: ‘list’, ‘source’: [‘Action1’, ‘Action2’]}) Is here somebody with experience with this that can help me? Thanks in advance, Alejandro.

DataValidation Drop down list in Excel using Python Scrpt node

mlauber71 December 20, 2018, 12:47am 8

Sorry for the late reply. Yes that should be possible with the openpyxl package.