Python, Jupyter Notebook, Programming, Microsoft Office, Excel.
Select the top left corner (or the whole range) and type “%xl_get” in your Jupyter notebook and voila! the Excel table is now a pandas DataFrame. Note: The %xl_get magic function requires the “pywin32” package. You can install this by running: pip install “pywin32==228” If you get a “DLL Load