Regular Expressions and LINQ

Regular expressions are a great, albeit sometimes overused, tool for parsing and extracting text data. Sometimes I find myself looking at a list of data that I want to execute a regular expression against. I could do a for loop or encode a Regex match in a lambda but both interrupt the flow and require […]

Query Excel File Using LINQ

Lately at work I’ve had to pull data from a variety of Excel worksheets. Excel interop is quite handy, but making sure to release the used COM objects and dealing with ranges can be quite a pain. I found a nice little article that shows a basic example of loading all the data from a […]