I think XLwings (https://www.xlwings.org) can do some of that.