I agree with everything you said, but (in Microsoft’s eyes) this is a feature - not a bug.
Without this cloud component, how could:
- Microsoft make sure that the accounting team does not introduce a malicious/old Python library into the Excel file?
- Microsoft protect its users from writing/running inefficient, buggy, or malicious Python code?
- Microsoft provide a Python runtime to users who do not know how to install Python?
- Microsoft charge to run code that you wrote in a free, open source software programming language on a device that you own?
That’s true, but how often have you heard a finance team member wanting a CSV file so they can more easily process the data using Pandas or visualize it with MatPlotLib? How many accountants or finance people (especially those that ask for everything in Excel) do you know that is comfortable writing even a single line of Python code? How many of the finance team’s Excel-based tools will Python integrate well with? What feature(s) does Python within Excel provide that Excel (formulas, pivot tables, VBA, Power Query, Power Pivot, etc.) does not provide that someone on the finance team would need? What advanced charting/dashboarding functionality does Python in Excel provide that isn’t better accomplished in PowerBI (if not handled by standard Excel charts/graphs)?
Don’t get me wrong - Microsoft’s implementation of Python in Excel has its merits and will solve some problems that otherwise would not be possible in Excel and will make some people happy. However, this is not the solution most people were expecting, asking for, or find useful.