Create Excels with C# and EPPlus: Import
Version 4.5.3.3 is the last version of EPPlus you can use without a license for commercial use.
See some alternatives if that is a dealbreaker for you!
We now have a blog series on an alternative Excel package ClosedXML
Which is basically on equal footing with EPPlus.
NSubstitute vs Moq
Comparing NSubstitute syntax with Moq, probably the most used mocking framework out there at the moment.
Create Excels with C# and EPPlus: Formulas & DataValidation
Version 4.5.3.3 is the last version of EPPlus you can use without a license for commercial use.
See some alternatives if that is a dealbreaker for you!
We now have a blog series on an alternative Excel package ClosedXML
Which is basically on equal footing with EPPlus.
.NET Number and Date Formatting
A cheat sheet with everything there is to know about formatting the primitive types, DateTimes and TimeSpans in .NET.
VB.NET vs C# Syntax differences
A cheat sheet outlining the syntax differences between VB.NET and C#. This post is written specifically for advanced C# developers with little to no VB.NET knowledge who need to do some VB.NET coding.
Because some things are just so similar but still confusingly different in VB.NET vs C#…
Along the way we’ll make some amazing discoveries like:
- There are things VB.NET just can’t do (pointers, …)
- There are a few cases where VB.NET code is shorter than its C# counterpart (gasp!)
- VB.NET defaults are not what you might expect from a strongly typed language due to its VB6 legacy (Option Strict, Explicit)
- There is some VB.NET only stuff that comes in handy from time to time
Synchronize Additional Folders With Dropbox Using Junction on Windows
Dropbox is great! I’m pretty sure you’ve already heard of it but for those who have not: It allows you to synchronize about 2 gig (and up to 16 gig with some effort) worth of documents, pictures or other files between your different computers, laptops or other mobile devices. The files are kept on your machine(s) and in the cloud, but they are also accessible from anywhere with a browser and shareable with everyone you’d like.
Notepad++ double click PHP variable including the $ sign
Built-in in Notepad++ since 2016:
Settings > Preferences > Delimiter > Add you character as part of word > $
Notepad++ Bookmarks
In many text-editors there are means to easily jump with the cursor between different points in the code and this is no different in Notepad++. Bookmarks have their own margin where they can be toggled with a mouse click.
Pragmatic Tip 2: Think! About Your Work
“Turn off the autopilot and take control. Constantly critique and appraise your work.”
— The Pragmatic Programmers
Pragmatic Tip 1: Care About Your Craft
“Why spend your life developing software unless you care about doing it well?”
— The Pragmatic Programmers
Yet Another Blog
Scott Hanselman said “Now, go write, create, commit.”. It took a while but here we are, blogging about “Programming and stuff”. I will be writing about languages and platforms I’m working on or learning about, solutions to problems I’ve struggled with and really any CS related topic I’m otherwise curious about.
