.Net, ADO.NET, ASP.NET, C#, Data Sources, Database, Excel, Excel 2003, Excel 2007, Excel 2010, Programming, Software, VB.NET

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

Import data from MS Excel into your .NET code

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 write code to interface with data from Excel. Continue reading “How to Loop Through an Excel Spreadsheet in a .NET Application”

Advertisements
.Net, Data Sources, MS Exchange, MS Office, MS Outlook, Outlook, Outlook 2010, Programming, Software, VB.NET, Visual Studio, VSTO

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 to MS Exchange.
Continue reading “Programatically Connecting to MS Exchange Using EWS”

.Net, ASP.NET, Excel, HTML, MS Office, Programming, Software, Technology, Tool, VB.NET, Web Development, WebForms

ClosedXML Nicely Formatted Header Row

Nice Header Row in Excel
Nice Header Row in Excel

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 my site (jwcooney.com) and browse the available categories. Continue reading “ClosedXML Nicely Formatted Header Row”