this post was submitted on 01 Jul 2025
62 points (95.6% liked)
Memes
51502 readers
936 users here now
Rules:
- Be civil and nice.
- 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
view the rest of the comments
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.
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. 🤦
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.
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 :)