Human genes renamed to stop Microsoft Excel from misreading them as dates (2020)

Re:Human genes renamed to stop Microsoft Excel from misreadi... by chasd00 on Monday April 11, 2022 @11:04AM (#30989790)

100k+ is pretty manageable in the Excel GUI. When you get above 1M then it starts getting dicey. I have a junior dev on my team that is very good at python. I only consider him "jr" in the language/tech he's assigned to work on daily, in python i consider him pretty solid.

When we need data work done on csv's larger than I can ask an Analyst to do in Excel I give it to him to write some python against. Finding and exploiting his python skills has won the guy a couple bumps in base pay.

[ Parent | on HN ]

Re:Human genes renamed to stop Microsoft Excel from misreadi... by Aloha on Monday April 11, 2022 @11:09AM (#30989864)

Very much agreed - and the upper limit is a little more fuzzy, and has more to do with file size, record complexity (how many columns), and what you want to do with the data.

At some point the overall pokeyness of excel when dealing with large datasets overcomes the inertia of "everyone already knows it" and "we'd need a environment to spin up something more complex".

[ Parent | on HN ]

Re:Human genes renamed to stop Microsoft Excel from misreadi... by charlieyu1 on Tuesday April 12, 2022 @02:35AM (#30999358)

I’m probably outdated on this, but old Excel format have an upper limit of 65536 rows and the new format has a limit of 1M rows. So that’s where I would estimate the limit of upper bound. Could be less, can’t really think it’s possible to have more.

[ Parent | on HN ]