How to create your own custom data types in Excel using ScriptLab and the Javascript API.

Important Links:

Try out the workbook with my custom data types: https://1drv.ms/x/s!As7G72Sl487JliYRnUs0P4hYYNQj?e=rIL25J

Github for the example using a Custom Function:
<a href="https://gist.github.com/smozgur/a34ad495fb75e19c3e21904875ef0170" target=”_blank” rel=”nofollow”>https://gist.github.com/smozgur/a34ad495fb75e19c3e21904875ef0170

Github for the example using an add-in: https://gist.github.com/smozgur/bf5276622820b1fbbec6690c1689762c

Table of Contents
(0:00) The quest for a perfect custom data type
(1:50) Download a workbook with working custom data types
(3:54) The back-end API
(5:17) ScriptLab add-in
(8:33) ScriptLab Function
(10:49) Visual Studio version
(12:00) Nerdvana check