> I wish it wasn't solely powered only by Microsoft Cloud and could support python running locally

Have a look at xlwings, which runs on any cloud and also locally.