4 ms·
I just won't take any spreadsheet app really seriously until someone comes anywhere near the Excel table object (which is queryable with the built-in Power BI!)
by quacked 4y ago
I just won't take any spreadsheet app really seriously until someone comes anywhere near the Excel table object (which is queryable with the built-in Power BI!).
I do think Google Sheets actually is much more pleasant to use than Excel, especially given the collaboration feature, but once you start getting fancy with Excel Query Pivot Tables anyone who's not an actual full-time developer starts salivating.
- patife 4y agoYou can query Rows with QUERY(), with the new PARSE() that uses JsonPath schema. Pretty powerful. Beyond that you can use the free Restful API. What exactly are your needs from Excel Query Pivot Tables? What’s the best of it?