Anpassning av .NET-funktionalitet för Microsoft Excel

Abstract

The .NET Framework is a widely used system component for Microsoft Windows. This thesis describes how the functionality of the framework can be adapted to Microsoft Excel. Specific operations, such as integration of user interfaces, database connections and the ability to divide programs into smaller components, are discussed. A number of architectural - and design patterns to facilitate development are analysed. Several techniques have been made up in consultation with experienced programmers. These techniques were further developed by implementing a number of test programs. The results of the study are a number of standard classes for future usage and a larger pilot project containing most of the analysed functionality.