Friday, October 18, 2024

Excel: Python, JavaScript, TypeScript, VBA, Macros, Power Query...

This reminds me of story of Stone Soup - Wikipedia
By adding interesting other tools to Excel, it becomes interesting and more useful
And more complicated and complex, too...

 
Introduction to Python in Excel - Microsoft Support

Python in Excel is currently rolling out to Enterprise and Business users running the Current Channel on Windows, starting with Version 2407 (Build 17830.20128). It’s available in preview for Family and Personal users running the Current Channel on Windows starting with Version 2405 (Build 17628.20164).

Excel JavaScript API overview - Office Add-ins | Microsoft Learn

Fundamentals for Office Scripts in Excel - Office Scripts | Microsoft Learn

Office Scripts are written in TypeScript, which is a superset of JavaScript

Differences between Office Scripts and VBA macros - Office Scripts | Microsoft Learn

Power Query and Office Scripts are both powerful automation solutions for Excel. 

What is Power Query? - Power Query | Microsoft Learn