ScipBe.Common.Office
3.1.0
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
<PackageReference Include="ScipBe.Common.Office" Version="3.1.0" />
paket add ScipBe.Common.Office --version 3.1.0
#r "nuget: ScipBe.Common.Office, 3.1.0"
// 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.
Learn more about Target Frameworks and .NET Standard.
-
- Interop.Microsoft.Office.Interop.OneNote (>= 1.1.0)
- Microsoft.Office.Interop.Outlook (>= 15.0.4797.1003)
NuGet packages
This package is not used by any NuGet packages.
GitHub repositories
This package is not used by any popular GitHub repositories.
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