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: MS Office

  • Programatically Connecting to MS Exchange Using EWS

    You can do a lot with your code when you write an application that communicates with your Exchange server. But getting the setup to work for you in Visual Studio isn’t always as intuitive as it should be. Here are the steps I went through getting my project in Visual Studio set up and connecting…

  • 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…

  • Pivot a Row or Column of Data in Excel

    Excel is a great tool for data manipulation. One feature that can come in handy is the ability to pivot a data row into a column or pivot data in a column of information into a row.