Re:Lambda: Turn Excel formulas into custom functions
by fomine3 on Monday December 07, 2020 @12:29AM
(#25329572)
Yes it's good but "revolutionize" is misleading.
Re:Lambda: Turn Excel formulas into custom functions
by Closi on Monday December 07, 2020 @02:13AM
(#25330028)
I don’t think it’s misleading, I mean everyone’s definition of “revolutionary” is different, but let’s put it into perspective: this is adding functions and recursion to one of the worlds most popular data analysis languages.
I think most people on this site know how powerful the concepts of functions and recursion can be!
* You can write it in one language (excel formula language)
* The language is simpler and known by almost all users, while Javascript and VBA are only used by a tiny proportion of users.
* The language is more secure (i.e. you can't execute arbitrary code, access files, call DLLs etc)
* Because of the above, users don't need any security permissions / get warnings when running it.
* Because they are standard excel formulas, you get OOTB support for other excel features such as dynamic array formulas and access to the full catalogue of worksheet functions (even in VBA, Application.Worksheet only had access to a few basic excel workbook functions, so if you wanted to do a Xlookup for example you are implementing it yourself with arrays and loops)