Epplus High Quality -
He added a comment to the new codebase, right above the using statement:
The CFO got his file. The company made its shipment decisions. No one knew Arjun had wrestled a ghost.
EPPlus, like all great libraries, had taught him a deeper lesson: EPPlus abstracts away the horror of Open XML’s SharedStringTable and CellValue types, but it cannot abstract away memory. The “deep story” isn’t about Excel—it’s about the gap between what we ask computers to hold and what they can actually hold. epplus
“You’re not writing Excel,” he muttered. “You’re resurrecting a corpse every time.”
Null. He’d written defensive code against nulls. But the null wasn't the problem. It was the memory of the null. He added a comment to the new codebase,
EPPlus, he remembered from the documentation, wasn’t just a writer. It maintained a full object model of the spreadsheet in RAM: styles, formulas, comments, hidden rows. Every cell you touched became a ExcelRangeBase object, a tiny ghost in memory. After three years of patches and feature creep, his app was loading the entire source template—all forty-two sheets, all conditional formatting, all pivot caches—just to write a single new column of data.
But Arjun knew.
He closed Visual Studio and opened a terminal. Time to rewrite.