3 ms·
Not to go all senselessly pedantic, but doesn't Excel have a limit of like 55,000 rows?
by dasil003 13y ago
Not to go all senselessly pedantic, but doesn't Excel have a limit of like 55,000 rows?
- hkmurakami 13y agoHe's saying his file has way more rows than that, so maybe they upped the limit in the more recent versions of excel? (I think he also wrote a bunch of VBA and hooked into some external systems too)
- objclxt 13y agoIf you're being pedantic, it's 1,048,576 rows from Excel 2007, 65,536 rows before that.
- hkmurakami 13y ago2^20 rows! :)
- Joeri 13y ago16 384 columns and 1 048 576 rows actually
- n00b101 13y ago2^14 columns * 2^20 rows * 8 bytes per cell = 128GB. Bang on.
- dagw 13y agoCurrent limit is 1,000,000 pr worksheet. However there is a tool called PowerPivot which lets you get around that limit and do analysis on larger data sets.
- chinpokomon 13y agoI didn't see this response when I replied to the parent. Power Pivot is pretty great when you can use it.
- deleted 13y ago[deleted]
- jjcr 13y agoNot since 2007 where it got bumped to over 1 million. http://office.microsoft.com/en-us/excel-help/excel-specifications-and-limits-HA103980614.aspx http://office.microsoft.com/en-us/excel-help/excel-specifica...
- willismichael 13y agoThe devil is in the details. Big Data is really a massive cluster of VMs running maxed out Excel spreadsheets, and instrumented to restart automatically and restore from redundant backup, a la RAID, when the Excel process crashes one of the Windows VMs.
- chinpokomon 13y agoNot when you use it with Power Pivot.