OpenPyXL - XLOOKUP an Entire Column across Multiple Excel Workbooks with Python | Data Automation

This video reviews how to apply the XLOOKUP function across multiple workbooks using 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/DataAutomation
🅿 https://www.patreon.com/DataAutomation

Video on how to use XLOOKUP with Python: https://youtu.be/tMwnSRdG3PA
What is up with that "_xlfn." code?: https://youtu.be/Qu7bGO6DkcM
Video on how to use the max_row attribute with Python: https://youtu.be/S0_ZOdVibpY

00:00 :: Intro and Workbook Review
02:20 :: XLOOKUP across Workbook with Python
05:17 :: Overview

#PythonExcelTutorial #openpyxl #data #DataAutomation #python #pythontutorial #excel #pythonautomation #pythonprogramming #xlookup #xlookupformula #referencing #jupyterlab

Видео OpenPyXL - XLOOKUP an Entire Column across Multiple Excel Workbooks with Python | Data Automation канала Data Automation