Use NPOI to build awesome looking Excel documents by using templates

How to use the .NET implementation of Apache's POI project (NPOI) to build awesome looking Excel 2003 (XLS) documents. The article describes the process of merging a template (formatted XLS document) with data entered through a ASP.NET Web Form.