My main dependence on Excel is being able to interact with pivot tables. I also have some VBA macros to help with formatting which I would welcome to be in python - alas it looks like what they're bringing is for the cloud only?
I haven't found any free, open source solutions around this including any for Jupyter notebooks (my preferred medium).