Image- enter image description here Image-enter image description here
I am trying to use Xlsx Writer framework provided in python. I want my drop down to contain Province/ state two digit code grouped under Province section and other suppliers grouped under suppliers
wk_sht.data_validation('M2:M1048576', {'validate': 'list',
'source': ['AB','BC','MB','NL','NT','NS','NU','ON','PE','QC','SK','YT'],
'source': ['FSD','XDM, ABBA'],
'error_title': 'Input value not valid!',
'error_message': 'Invalid Choice !!!!!! Please enter a valid choice !! Enter Yes or No'})
Want something like this please check image