“Now you can do advanced data analysis in the familiar Excel environment by accessing Python directly from the Excel ribbon,” Stefan Kinnestrand, the GM for Modern Work at Microsoft, explains.

“Since Neptyne natively speaks Python, it means that the AI doesn’t just help you write formulas or visualize data — you can have a dialog with the AI about the spreadsheet application in ...

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.