ScipBe.Common.Office 3.1.0

There is a newer version of this package available.
See the version list below for details.
dotnet add package ScipBe.Common.Office --version 3.1.0                
NuGet\Install-Package ScipBe.Common.Office -Version 3.1.0                
This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package.
<PackageReference Include="ScipBe.Common.Office" Version="3.1.0" />                
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add ScipBe.Common.Office --version 3.1.0                
#r "nuget: ScipBe.Common.Office, 3.1.0"                
#r directive can be used in F# Interactive and Polyglot Notebooks. Copy this into the interactive tool or source code of the script to reference the package.
// Install ScipBe.Common.Office as a Cake Addin
#addin nuget:?package=ScipBe.Common.Office&version=3.1.0

// Install ScipBe.Common.Office as a Cake Tool
#tool nuget:?package=ScipBe.Common.Office&version=3.1.0                

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 or CSV file and provides column definition and row collections. The OutlookProvider is a wrapper class which provides collections to data of Outlook (AppointmentItems, ContactItems, MailItems, TaskItems, ...). The OneNoteProvider provides collections of Notebooks, Sections and Pages by parsing the XML hierarchy tree of OneNote.  All collections are IEnumerable so you can query them with LINQ. There are also 3 separated NuGet packages with for the Excel, Outlook and OneNote provider so they can be used standalone.

There are no supported framework assets in this package.

Learn more about Target Frameworks and .NET Standard.

NuGet packages

This package is not used by any NuGet packages.

GitHub repositories

This package is not used by any popular GitHub repositories.

Version Downloads Last updated
3.1.1 66 1/28/2025
3.1.0 114 1/6/2025
3.0.0 1,501 5/30/2022
2.0.3 939 5/24/2022
2.0.1 2,264 6/28/2017
2.0.0 3,007 6/28/2017
1.3.0 6,111 7/19/2011

Version 3.1.0 (January 2025)
- Switched to Microsoft Access Database Engine 2016 Redistributable for reading Excel XLSX and XLS files
- Removed the support for reading CSV files. The CSVHelper library is a much beter alternative: https://joshclose.github.io/CsvHelper/
- Updated Microsoft Office Outlook Interop nuget package to latest version 15.0.4797.1003
- Upgraded unit test project to .NET 8.0 in stead of old .NET 4.6
- Updated LinqPad scripts with examples