Openpyxl - Change the Options in a Dropdown List in Excel Workbooks with Python | Data Automation
This video reviews how to use Python's library OpenPyXL to change the options provided in a Data Validation List object in an Excel Workbook. I use Anaconda's Jupyter Lab interface.
😄 Please consider supporting this channel and making this content possible:
☕ https://www.buymeacoffee.com/DataAuto...
🅿 / dataautomation
00:00 :: Intro and Workbook Review
00:37 :: Reviewing our Data Validation List Options
02:05 :: Changing the Options
03:14 :: Overview
#PythonExcelTutorial #openpyxl #data #DataAutomation #python #pythontutorial #excel #pythonautomation #pythonprogramming #jupyterlab #datavalidation #dropdownlist