183
Microsoft is bringing Python to Excel
(www.theverge.com)
Welcome to the Python community on the programming.dev Lemmy instance!
October 2023
November 2023
Past
July 2023
August 2023
September 2023
The code storage for Python is no different than regular Excel functions (eg -
VLOOKUP()
,SUM()
, etc.), meaning that it is stored within an Excel cell. The only differences are that Python code is run remotely vs Excel functions running locally and the location of Python's code matters vs Excel's functions are location agnostic (ie - Python code runs in cells located left-to-right, top-to-bottom but Excel's functions can dynamically determine the calculation order/location).I'm not sure that this new Python integration changes much about this use case (except for another way to accomplish the same/similar tasks).