LINQ to Outlook/OneNote/Excel
The ScipBe.Common.Office namespace contains 3 classes : OutlookProvider (LINQ to Outlook), OneNoteProvider (LINQ to OneNote) and ExcelProvider (LINQ to Excel). 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. And the ExcelProvider loads an Excel worksheet and provides column definition and row collections. All collections are IEnumerable so you can query them with LINQ.
This TscExcelExport component is an advanced, powerful but easy to use component which enables you to export all records of a dataset from Embarcadero Delphi to Microsoft Excel. Many features are provided to change the layout, use conditional formatting, to add totals, to create groups, to set a filter, ... The component works in Delphi 5, 6, 7, 2006, 2007, 2009, 2010, XE, XE2, XE3, XE4, XE5, XE6, XE7, XE8, 10 Seattle, 10.1 Berlin, 10.2 Tokyo, 10.3 Rio, 10.4 Sydney and it supports all Excel versions from 97 to 2019.
With this component you can retrieve the most important system information like the Windows version, the username, the name of the PC, the speed of the CPU, the available memory, Delphi and Office version, ...