News for hackers. Stuff that matters.

A comment on Use Spreadsheets Everywhere. Parent comment

Re:Use Spreadsheets Everywhere by tomnipotent on Tuesday August 03, 2021 @11:38AM (#28050487)
Most people have no clue these features exist, or that Excel even has advanced data modeling that supports all sorts of goodies including strict types and joins/merges/appends. It's not as accessible as just basic sheets, but I've had no problem crunching millions of rows of data in Excel with sub-second response times.
[ Parent | on HN ]
Re:Use Spreadsheets Everywhere by piyh on Tuesday August 03, 2021 @12:38PM (#28051235)
Powerquery is great, but too bad it breaks with version upgrades.
[ Parent | on HN ]
Re:Use Spreadsheets Everywhere by jjtheblunt on Tuesday August 03, 2021 @01:35PM (#28051908)
isn't excel limited to just over a million rows?
[ Parent | on HN ]
Re:Use Spreadsheets Everywhere by tomnipotent on Tuesday August 03, 2021 @02:06PM (#28052198)
Excel 2013 and later has a columnar database capable of handling millions of rows, but not through the standard sheets interface so it loses a lot of the utility people are used to.
[ Parent | on HN ]
Re:Use Spreadsheets Everywhere by jodrellblank on Tuesday August 03, 2021 @05:25PM (#28054427)
How? Through what interface, or by what feature name to Google?
[ Parent | on HN ]
Re:Use Spreadsheets Everywhere by easton on Tuesday August 03, 2021 @08:36PM (#28055956)
Excel refers to it as the “Data Model”. It allows joining tables/sheets and referencing them from other tables.

https://www.microsoft.com/en-us/microsoft-365/blog/2012/08/2...

[ Parent | on HN ]
Re:Use Spreadsheets Everywhere by jodrellblank on Tuesday August 03, 2021 @10:29PM (#28056544)
Thanks :)
[ Parent | on HN ]
Re:Use Spreadsheets Everywhere by blowski on Tuesday August 03, 2021 @02:12PM (#28052258)
Yes, although you can have multiple sheets each with a million rows. Kind of like sharding.

But I’d be fascinated what kind of system spec is required to get good performance on those kind of numbers. I’ve been on a Mac for years, where Excel is crippled by limitations.

[ Parent | on HN ]
Re:Use Spreadsheets Everywhere by LegitGandalf on Wednesday August 04, 2021 @10:28PM (#28069082)
Working with a Mac for the first time this year, excel on Mac is actually worse than excel 2010 :(
[ Parent | on HN ]