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/DataAuto...
🅿 / dataautomation
Video on how to use XLOOKUP with Python: • Openpyxl - XLOOKUP Function on an Ent...
What is up with that "_xlfn." code?: • Openpyxl - Fix/Resolve the XLOOKUP @ ...
Video on how to use the max_row attribute with Python: • Openpyxl - Finding the Last/Max Row a...
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