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.