News
Photos
Articles
Components
Applications
Kleinkunst

LINQ Outlook, OneNote and Excel

Version 2.0
June 2017
C#
.NET 4.6
open source
nuget
github

The ScipBe.Common.Office namespace contains 3 classes : ExcelProvider (LINQ to Excel), OutlookProvider (LINQ to Outlook) and OneNoteProvider (LINQ to OneNote). The ExcelProvider loads an Excel worksheet and provides column definition and row collections. The OutlookProvider is a wrapper class which provides IEnumerable collections to data of the COM interface of Outlook ( appointments, contacts, mails, tasks, ...). The OneNoteProvider provides collections of notebooks, sections and pages by manipulating the XML hierarchy tree of OneNote. All collections are IEnumerable so you can query them with LINQ.

Check out my articles where I describe the implementation of these 3 classes and how to use them. These articles also contain a lot of LINQ query examples.

Class diagrams:

 

Copyrights and distribution

  • These components are open source (MIT License) and may be freely distributed.
  • The author doesn't give a warranty for error free running of these components and he doesn't give any support.
  • See source code and help file for more information about the classes, interfaces, properties, methods, events, ...

Source code and packages