DataValidation Drop down list in Excel using Python Scrpt node
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.