this post was submitted on 01 Jul 2025
61 points (95.5% liked)

Memes

51483 readers
347 users here now

Rules:

  1. Be civil and nice.
  2. Try not to excessively repost, as a rule of thumb, wait at least 2 months to do it if you have to.

founded 6 years ago
MODERATORS
you are viewing a single comment's thread
view the rest of the comments
[–] [email protected] 4 points 1 week ago (2 children)

I don't know what you're trying to do with Excel, but based on your posts, I can only wish you good luck. I'm happy to say that I have been able to outsource low level parsing to third party libraries for my needs so far. Well, except the interpreting semantic formatting part. That was on me.

[–] [email protected] 3 points 1 week ago* (last edited 1 week ago)

And don’t forget that 1900 still is a leap year in Excel.

Thank you! Saying this finally made me realize why I always need to add/subtract one day when I’m trying to convert dates to and from the Excel representation. 🤦

[–] [email protected] 4 points 1 week ago (1 children)

I have been able to outsource low level parsing to third party libraries

Hahaha!!!

Today I watched a Java server crash because a library decided it needed more than 3GB of heap space to read a 10MB file. That was after manually removed background colors from around 100,000 cells, which apparently caused the parser to create even more objects in its internal representation of the sheet.

[–] [email protected] 2 points 1 week ago

Yeah, I get it. I've had many libraries fail me in as many ways, which is why I consider it lucky to not have to implement my own. I work in .net these days, but there have been times where I had to just dig into the xml inside the xlsx and use xml tools. Those were mostly one-offs, thankfully.

Back when I did Java I had a frustrating experience with IBM's libxml causing our app to crash after several days due to a memory leak. I didn't have access to the production environment so it took me probably 3 weeks to find the cause and only after digging through a crash dump provided by the sysadmin. Not related, but you triggered my traumatic memory :)