When AI Can’t Save You: Solving a Spreadsheet Parsing Problem the Old-Fashioned Way
In modern development, we rely heavily on AI to assist with coding, debugging, and architectural decisions. But every once in a while, a problem comes along that AI can’t quite crack—at least not without a developer who understands the underlying language and can think beyond AI’s suggestions. Recently, I ran into exactly that scenario while working with an application that uses Excel spreadsheets as a data source. Yes, it’s not ideal. No, that part isn’t changing. The real issue was something far more painful: The spreadsheet columns kept changing positions. Every time a new spreadsheet arrived, the columns shifted around unpredictably. This caused the parser to misalign fields, break imports, and generally ruin my day. What We Tried (with AI’s Help) I paired with AI to generate a variety of solutions: Custom Excel parser using NuGet packages CSV parser variants Multiple fallback strategies Different libraries for column mapping and validation These solution...