Justin Cooney

Web Development Tips and Examples

recent posts

about

I am a Senior Applications Programmer / Analyst with years of experience developing enterprise solutions using the Microsoft technology stack including C#, VB.NET, ASP.NET, AJAX, IIS and SQL Server. I specialize in Web application development with a focus on building secure systems, integrating applications, and designing robust database structures.

Category: Excel

  • CMD Program Startup Commands

    This is my list of handy commands you can use to start up various tools and applications from the DOS Command prompt in Windows. The Windows “cmd” DOS window is good for getting things done quickly from a single spot instead of having to hunt them down wherever Microsoft has decided to hide them in…

  • How to Loop Through an Excel Spreadsheet in a .NET Application

    MS Excel is a great tool that a lot of employees at a company are very familiar with using. It helps structure and organize data in a way that is very intuitive to users without the users needing to be especially technical. So it should come as no surprise that sometimes you will want to…

  • ClosedXML Nicely Formatted Header Row

    In this article I’ll show a simple example of nicely formatting a header row in a generated Excel document (using the open source ClosedXML library). If you would first like some background into setting up and calling functions using .Net and the ClosedXML library, have a look at a previous article I wrote, or visit…