Get 52 hours of Excel, VBA, and Python training for under £50 Get lifetime access to loads of courses and 52 hours of content.

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.

Microsoft today announced the public preview of Python in Excel, which will allow advanced spreadsheet users to combine scripts in the popular Python language and their usual Excel formulas in the ...