all blog posts

JavaScript Testing: Getting started with Jasmine

Probably the most widely used JavaScript testing framework.

This tutorial covers installation, configuration and execution only. For the Jasmine syntax, see parts 2 to 4!

29 May 2017
tutorial testing

Create Excels with C# and EPPlus: Miscellaneous

Miscellaneous features

EPPlus can do a whole lot more for you. This post covers some interesting stuff that didn’t really fit anywhere else.

2 May 2017
excel tutorial

Create Excels with C# and EPPlus: Import

IEnumerable objects

Exporting data to an Excel doesn’t get easier than this

using (var package = new ExcelPackage())
	var sheet = package.Workbook.Worksheets.Add("IEnumerable");
	var data = new[]
		new {Name = "A", Value = 1},
		new {Name = "B", Value = 2},
		new {Name = "C", Value = 3},
	sheet.Cells["A1"].SetHeaders("Name", "Value");
	package.SaveAs(new FileInfo(@""));
1 May 2017
excel tutorial

NSubstitute vs Moq

Comparing NSubstitute syntax with Moq, probably the most used mocking framework out there at the moment.



30 Apr 2017
tutorial testing

Create Excels with C# and EPPlus: Formulas & DataValidation

In case your users want to continue working with the Excels after generation.

Not a problem for EPPlus. Instead of calculating values and writing them to an excel, leverage the power of Excel formulas.

27 Apr 2017
excel tutorial

Create Excels with C# and EPPlus: A tutorial

Quick tutorial about creating xlsx Excels with C# and the EPPlus nuget package.

EPPlus Excel addresses are not zero based: The first column is column 1!

Also, before writing any loops, you might want to check out the LoadFromXXX methods. They are explained in depth in part 3 Import.

26 Apr 2017
excel tutorial

Advanced Windows Explorer

A listing of handy but less known shortcuts in Windows Explorer and some Autohotkey examples on how to add extra functionality.

Open Windows Explorer, the most direct way:

Win + E : Open Windows Explorer

22 Apr 2017
autohotkey powershell windows

PowerShell and Git for the colorblind

My PowerShell, Posh-Git and .gitconfig color configuration because of some red-green troubles with the default configurations.

21 Apr 2017
powershell git