4 ms·
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
by jugg1es 8y ago
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.
- andylynch 8y agoTry powerQuery (Microsoft’s addon for just this) - it does it really well
- gerdesj 8y agoAs 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 ...
- gandalfgeek 8y agoGoogle Sheets has a QUERY function which does exactly this. https://support.google.com/docs/answer/3093343?hl=en https://support.google.com/docs/answer/3093343?hl=en
- samanator 8y agoThis 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...)
- digsy 8y agoQueryStorm does this - https://www.querystorm.com/ https://www.querystorm.com/