Rows 2.0: The easiest way to use data on a spreadsheet

Re:Rows 2.0: The easiest way to use data on a spreadsheet by quacked on Thursday March 02, 2023 @07:10PM (#35003924)

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.

[ Parent | on HN ]

Re:Rows 2.0: The easiest way to use data on a spreadsheet by patife on Friday March 03, 2023 @02:59AM (#35006990)

You 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?

[ Parent | on HN ]