News for hackers. Stuff that matters.
Re:Applying programming language research ideas to transform... by jugg1es on Saturday January 19, 2019 @03:41PM (#18949052)
As a programmer, excel would be so much more useful if it allowed you to do things like filtering and selects using SQL or some other code so you didn't have to rely on the UI so much to do filtering.
Re:Applying programming language research ideas to transform... by andylynch on Saturday January 19, 2019 @03:44PM (#18949062)
Try powerQuery (Microsoft’s addon for just this) - it does it really well
Re:Applying programming language research ideas to transform... by gerdesj on Saturday January 19, 2019 @04:19PM (#18949238)
As well as that you can roll your own functions which can be used in cells just like the native ones and call out to other languages and the shell. It really is rather powerful for minimal effort.

However, with great power comes great responsibility ...

Re:Applying programming language research ideas to transform... by gandalfgeek on Saturday January 19, 2019 @11:14PM (#18951015)
Google Sheets has a QUERY function which does exactly this.

https://support.google.com/docs/answer/3093343?hl=en

Re:Applying programming language research ideas to transform... by samanator on Sunday January 20, 2019 @01:53AM (#18951576)
This works for one offs. But performance is non-existent when you try to mock up google sheets as a database. I'm in the process of switching a company from google sheets + google sheets query to postgres. Loading one of their google sheets takes around 60 seconds. If they move around one of their 'id' columns it takes 5-10 minutes for everything to recalculate (also keep in mind that google offloads the computations onto the user's CPU...)
Re:Applying programming language research ideas to transform... by digsy on Sunday January 20, 2019 @06:35PM (#18956324)
QueryStorm does this - https://www.querystorm.com/