Excel articles

On this page you will find an overview of all articles that I have written myself. The more recent articles deal with software development with .NET (C#, Visual Studio, VSTS, Azure, LINQ, Entity Framework, Web services, WPF, Silverlight, ...) in particular. The older articles were often written for the purposes of courses or demonstrations at my computerclub and these articles are mostly about Delphi, PHP, databases, Javascript, Windows, Office, Multimedia applications, Atari, ...

Use the left panel to filter the more than 115 articles by category. These articles can be used freely for personal use. Placing the full articles on other websites is not allowed without the permission of the author.

Documentation Delphi TscExcelExport component

English

Delphi

Excel

Documentation, release notes and many examples of the Delphi VCL TscExcelExport component (in PDF format). The last version of this component works in Embarcadero Delphi 10 Seattle, 10.1 Berlin, 10.2 Tokyo, 10.3 Rio and 10.4 Sydney and it supports all Excel versions from Office 97 to 2019.

.NET - Querying Excel worksheets with LINQ

English

.NET

Office

Excel

LINQ

LINQPad

A while ago I was looking for a way to query Excel with LINQ. I needed a simple solution that allowed me to query tables in Excel worksheets in a tool like LINQPad. This article will describe how I implemented my ExcelProvider and it will demonstrate its features by giving an example of a LINQ query and the result in LINQPad.

Excel - Create your own functions with VBA

Dutch

Office

Excel

Scripting

This article contains several examples of VBA (Visual Basic for Applications) functions for Excel.