.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
Programming, VB.NET, Software, Data Sources, .Net, MS Office, Outlook, Outlook 2010, VSTO, Visual Studio, MS Outlook, MS Exchange

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”

Internet Explorer, Programming, SharePoint, Software

SharePoint: Getting EML Emails to Open in Outlook

SP_Custom_Menu
SP_Custom_Menu

If you are sending emails to a SharePoint document library, they get saved as .eml files rather than .msg like when you drag and drop emails into SharePoint. Unfortunately .eml files do not always handle as nicely as .msg files and require extra steps to open. The challenge is to get those files to open for your users when they click on the file. In this article I’ll review the basic steps for making this happen, but you may need to dig deeper depending on your situation. Continue reading “SharePoint: Getting EML Emails to Open in Outlook”