Working with Excel Tables in Python
Tutorial on working with Excel Tables in Excel using the Python Excel add-in PyXLL.
00:00 - Intro
00:41 - Getting Started
01:07 - Writing an Excel macro in Python
02:41 - Writing values to Excel from Python
03:14 - Writing a Python DataFrame to Excel range
04:48 - Writing a Python DataFrame as an Excel Table
06:50 - Reading values from an Excel Table in Python
08:25 - Using Tables in Worksheet Functions (UDFs)
11:11 - Wrapping Up
Resources
=========
PyXLL (Python add-in for Excel):
https://www.pyxll.com
Working with Excel Tables with PyXLL:
https://www.pyxll.com/docs/userguide/...
Writing Excel Macros in Python:
https://www.pyxll.com/docs/userguide/...
Writing Excel Worksheet Functions (UDFs) in Python:
https://beta.pyxll.com/docs/userguide...