Openpyxl - Reading the Options in a Dropdown List in Excel Workbooks with Python | Data Automation

This video reviews how to read into Python the options provided in a Data Validation List object from an Excel Workbook. I use the Python library Openpyxl. I use Anaconda's Jupyter Lab interface.

😄 Please consider supporting this channel and making this content possible:
☕ https://www.buymeacoffee.com/DataAuto...
🅿 Patreon: DataAutomation

00:00 :: Intro and Workbook review
00:57 :: Reading Options from One Data Validation Object
02:50 :: Reading Options from Multiple Data Validation Object
06:45 :: Overview

#PythonExcelTutorial #openpyxl #data  #DataAutomation #python #pythontutorial #excel #pythonautomation #pythonprogramming #jupyterlab #datavalidation #dropdownlist

• #people_blogs
• #descript