Re:Lambdas as values in Excel
by pjmlp on Monday August 23, 2021 @07:46AM
(#28274458)
And an F# like language, Power Query.
[ Parent
| on HN ]
I haven’t heard of this before. Do you happen to have any more details?
EDIT: Found it: https://docs.microsoft.com/en-us/power-query/. But it doesn’t look particularly F#-like — Power Query seems more focused around, well, querying data.
I think parent comment was referring to the M-code [0]
Yep that was it.
Ah, thanks!
I really like the M Language and Power Query (PQ) makes it really easy and convenient to build data mashups. You can even use it as a SQL query builder by viewing the Native Query code and then copying that.
The main issue I'm facing is how to distribute the library of PQ/M functions I've developed?
Currently I have a central library workbook and then have to copy code from there. Problem is that updates and bugfixes don't flow downstream.
I really hope Microsoft creates a solution for this. Would love to hear about some approaches for handling this in the meantime.
There are a few third party libraries/projects that are useful for that situation. Libpq[1] is one, and this[2] project is another. The readme for that second one includes links to several other M/PQ related projects.