4 ms·

Excel now has MAP, REDUCE and other helper functions for functional programming. See also https://insider.office.com/en-gb/blog/new-lambda-functions-available-

• pjmlp 5y ago
  And an F# like language, Power Query.
  • bradrn 5y ago
    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/ 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.
    • vhhn 5y ago
      I think parent comment was referring to the M-code [0] [0](https://www.howtoexcel.org/power-query/m-code/ https://www.howtoexcel.org/power-query/m-code/)
      • pjmlp 5y ago
        Yep that was it.
      • bradrn 5y ago
        Ah, thanks!
  • snthpy 5y ago
    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.
    • cosmie 5y ago
      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. [1] https://libpq.ml/ https://libpq.ml/ [2] https://github.com/KiaraGrouwstra/pquery https://github.com/KiaraGrouwstra/pquery