Python is now integrated into Excel via Microsoft 365, allowing users to write Python code directly in spreadsheets using the `=PY` formula, enhancing data analysis and visualization capabilities.

Python and Excel can only really talk to each other through limited functions—xl() and =PY()—that can only return code results, not macros, VBA code, or other data, Microsoft claims.