Python, Jupyter Notebook, Programming, Microsoft Office, Excel.
in Python? The Excel Object Model is what you use when writing VBA, but the same API is available in Python as well. See Python as a VBA Replacement from the PyXLL documentation for details of how this is possible. In a Jupyter notebook running in Excel the entire Excel Object Model is available