[narush]

Very cool! For anyone wondering, before 2003 Excel only supported 65,536 rows. It now has a hard limit 1,048,576 rows.

Google sheets is a bit harder to figure out -- it doesn't have an explicit row limit, but does have a cell limit of 10M cells - so depending on your number of columns you can back out to the max rows.

If you want to see some practical effects of these row limits, check out the time that England misreported thousands of covid cases - because their Excel file ran out of space silently [1]. Oops.

This looks like a pretty sweet engineering effort! Anything cool you learned while building this that you can share here that helped you achieve this performance? What language did you use to build this application?

I'm asking for interest and for selfish reasons -- fellow spreadsheet builder of Mito [2] - which is pretty much just a UI wrapper for Pandas dataframes (and so can support 10M+ rows as well).

[1] https://www.bbc.com/news/technology-54423988 [1] https://trymito.io

[jpiech]

Thanks. It's C++, mostly with custom template classes instead of the STL.