Querying other databases from SQLite

For such a tiny database engine, SQLite can really do a lot. It also offers many extensibility points, which QueryStorm makes good use of. QueryStorm extends its SQLite engine so that it can see Excel tables as if they were regular database tables. But did you know that the SQLite database can also access data […]

SQLite, C# and Excel

SQLite is a remarkable little database engine. Although it serves a different purpose, it can do much of what the big client-server databases can do. It’s fast, reliable, extremely well tested and feature rich. However, if you need a function that SQLite does not offer, defining one for yourself can be tricky. Not so in […]

Fast prototyping with C# and Excel

Excel doesn’t have much of a reputation as a developer tool. But imagine if instead of VBA you could use C#. Would this change things? I guess it depends. Admittedly, I’m a bit biased (since I wrote QueryStorm), but I find the combination of C# and a spreadsheet really useful. It lets me quickly build […]

Regex in Excel

Download the demo workbook to follow along. You should have QueryStorm installed, but a paid license is not necessary. If you’re reading this article, chances are you’re the type of person who enjoys an occasional expression of the regular kind. If so, I’m sure you’ll find this article interesting, regardless of how much you use […]