ExcelDna.Testing 0.1.0-preview

'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.

This is a prerelease version of ExcelDna.Testing.
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" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add ExcelDna.Testing --version 0.1.0-preview
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
#r "nuget: ExcelDna.Testing, 0.1.0-preview"
#r directive can be used in F# Interactive, C# scripting and .NET Interactive. Copy this into the interactive tool or source code of the script to reference the package.
// Install ExcelDna.Testing as a Cake Addin
#addin nuget:?package=ExcelDna.Testing&version=0.1.0-preview&prerelease

// Install ExcelDna.Testing as a Cake Tool
#tool nuget:?package=ExcelDna.Testing&version=0.1.0-preview&prerelease
The NuGet Team does not provide support for this client. Please contact its maintainers for support.

NuGet packages

This package is not used by any NuGet packages.

GitHub repositories

This package is not used by any popular GitHub repositories.

Version History

Version Downloads Last updated
0.1.0-preview 187 10/31/2020