'ExcelDna.Testing' is a NuGet package and library that lets you develop automatic tests for Excel models and add-ins, including add-ins developed with Excel-DNA and VBA. Test code is written in C# or Visual Basic and is hosted by the popular xUnit test framework, allowing automated tests to run from Visual Stuio or other standard test runners.
Tests developed with the testing helper will run with the add-in loaded inside an Excel instance, and so allow you to test the interaction between an add-in and a real instance of Excel. This type of 'integration testing' can augment 'unit testing' where individual library features are tested in isolation. It is often in the interaction with Excel where the problematic aspects of an add-in are revealed, and developing automated testing for this environment has been difficult.
The testing helper allows flexibility and power in designing automated Excel tests:
* The test code can either run in a separate process that drives Excel through the COM object model, or can be loaded inside the Excel process itself, allowing use of both the COM object model and the C API from the test code.
* Functions, macros and even ribbon commands can be tested.
* Test projects can include pre-populated test workbooks containing spreadsheet models to test or test data.
Install-Package ExcelDna.Testing -Version 0.1.0-preview
dotnet add package ExcelDna.Testing --version 0.1.0-preview
<PackageReference Include="ExcelDna.Testing" Version="0.1.0-preview" />
paket add ExcelDna.Testing --version 0.1.0-preview
This package is not used by any NuGet packages.
This package is not used by any popular GitHub repositories.