.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, C#, Programming, Software, VB.NET, Visual Studio 2010, Visual Studio 2013

Example of Setting up a Blank Windows Service in Visual Studio 2017

When you are creating a new Windows Service Application in NET, you can’t simply generate the project and then click F5 to debug in Visual Studio. You need to follow a few setup steps to get the service to work. In the article below I’ll explain the basics along with a code sample. Continue reading “Example of Setting up a Blank Windows Service in Visual Studio 2017”

C#, msoControlComboBox, Programming, SharePoint, Software, Technology, VB.NET, VSTO

VSTO Add a Menu Item to Outlook and Save an Email into SharePoint

SharePoint Documents List
SharePoint Documents List

Some really cool functionality that you can put together is to automate saving emails from your Outlook email application to be stored in a SharePoint document list. This lets your users keep using the tools they are comfortable working with (such as Outlook), but helps make sure that important emails are backed up to a reliable storage and reporting medium like SharePoint with as little effort on the user’s part as possible.   Continue reading “VSTO Add a Menu Item to Outlook and Save an Email into SharePoint”