As I outlined in my previous post, the so-called principles of SOLID are not principles at all. I actually don’t believe it’s possible to create a universal set of principles for all contexts and domains, so I’m not going to try. Instead, I’m going to outline some practices which have helped me when writing websites and web-services. I call this approach simple code. (I certainly didn’t come up with the name.)
Every software developer (hopefully) strives to write code which is robust and maintainable. We’ve all worked on projects where a simple code-change broke a million seemingly unconnected features, or random bugs kept popping up in production as soon as the system was used by more than three people, or vast swathes of the codebase were deemed untouchable because nobody could understand how they worked. Over the past three decades, a number of architectural principles, design patterns, cure-alls and get-rich-quick schemes have emerged, promising a life free of production bugs and technical debt.
In my previous post I looked at handling hyperlinks when importing Google spreadsheets via the C# SDK. Today, I continue the GSuite theme with a short piece on importing Excel workbooks into the Google Sheets format via the C# SDK. (Since these posts are so closely related, I decided to post them together.)
Recently, when writing a script to import data from Google Sheets into a database using the C# SDK, I came across a problem handling pasted hyperlinks in the source spreadsheet. The solution in the end was, thankfully, fairly straightforward, but Google’s documentation was quite poor, and I found little useful information on the web. Hopefully this post will save a few developers some time (and prevent a few grey hairs in the process).
Welcome to my blog, where I’ll be sharing my thoughts on writing beautiful, clean code, making remote teams work well together across multiple continents and timezones, doing automated testing in a pragmatic, effective way, and many other topics (including the occasional detour into Star Trek, Golden Age science fiction, and Huddersfield Town).
