<story><title>Excel Adds JavaScript and Power BI Support</title><url>https://dev.office.com/blogs/azure-machine-learning-javascript-custom-functions-and-power-bi-custom-visuals-further-expand-developers-capabilities-with-excel</url></story><parent_chain></parent_chain><comment><author>Daiz</author><text>A bit surprised that there&amp;#x27;s no TypeScript support, especially considering how verbose metadata you have to write as a result[1]. That whole thing could be made much simpler with some TS and JSDoc, eg.&lt;p&gt;&lt;pre&gt;&lt;code&gt;    &amp;#x2F;**
     * adds 42 to the input number
     * @param a the first number to be added
     * @param b the second number to be added
     *&amp;#x2F;
    function ADD42(a: number, b: number): number {
      return a + b + 42;
    }
&lt;/code&gt;&lt;/pre&gt;
[1] &lt;a href=&quot;https:&amp;#x2F;&amp;#x2F;docs.microsoft.com&amp;#x2F;en-us&amp;#x2F;office&amp;#x2F;dev&amp;#x2F;add-ins&amp;#x2F;excel&amp;#x2F;custom-functions-overview&quot; rel=&quot;nofollow&quot;&gt;https:&amp;#x2F;&amp;#x2F;docs.microsoft.com&amp;#x2F;en-us&amp;#x2F;office&amp;#x2F;dev&amp;#x2F;add-ins&amp;#x2F;excel&amp;#x2F;cu...&lt;/a&gt;</text></comment>
<story><title>Excel Adds JavaScript and Power BI Support</title><url>https://dev.office.com/blogs/azure-machine-learning-javascript-custom-functions-and-power-bi-custom-visuals-further-expand-developers-capabilities-with-excel</url></story><parent_chain></parent_chain><comment><author>rb808</author><text>VBA is well obsolete by now. I was really hoping they&amp;#x27;d add C# or python to Excel. Yes you can use VSTO to write modules but that isn&amp;#x27;t the same - you can&amp;#x27;t send a spreadsheet with C# embedded like you can with VBA.&lt;p&gt;As a result I&amp;#x27;m using Python and Jupyter notebooks now, not as friendly as Excel but at least its modern and there are lots of libraries out there to make the platform super powerful.</text></comment>