Readit News logoReadit News

Dead Comment

Dead Comment

Dead Comment

edrobap commented on What’s the origin of the phrase “big data doesn’t fit in excel”?   shkspr.mobi/blog/2021/04/... · Posted by u/edent
random5634 · 5 years ago
Do a ton of excel work - the 1m row limit is surprisingly low. And sharding across worksheets is miserable in my view
edrobap · 5 years ago
It amuses me how the low limit nature of Excel has affected the ecosystem around it. Apache POI, which is a popular library to operate on Excel files, has a weird 4GB limit [1] on uncompressed file size.

throw new IllegalArgumentException("Max entry size is bounded [0-4GB], but had " + maxEntrySize);

[1] https://svn.apache.org/viewvc/poi/tags/REL_5_0_0/src/ooxml/j...

Dead Comment

u/edrobap

KarmaCake day9October 1, 2015View Original