Drop down data velidation doesn't work.
It causes, that the excel file is corrupted when try to open it...
dv_aging = DataValidation(type="list", formula1='"0-3 month","3-6 month",">6 month"', allow_blank=True,showDropDown = False) dv_aging.error ='Your entry is not in the list' dv_aging.errorTitle = 'Invalid Entry' as_LAM_template_data_sheet.add_data_validation(dv_aging) dv_aging.add('BD3:BD24576')