Sign in Sign up
nuget

ExcelDna.Testing

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

nuget View on Nuget

Activity

Latest release
2mo ago
Total releases
42
Cadence
~24 days
Last 12 months
3

Details

First release
Oct 31, 2020
Releases
Version Released
1.10.0-preview5 pre
1.10.0-preview4 pre
1.10.0-preview1 pre
1.9.0 minor
1.9.0-rc6 pre
1.9.0-rc5 pre
1.9.0-rc4 pre
1.9.0-rc3 pre
1.9.0-rc2 pre
1.9.0-rc1 pre
1.9.0-beta2 pre
1.9.0-beta1 pre
1.9.0-alpha3 pre
1.9.0-alpha2 pre
1.8.0 minor
1.8.0-rc pre
1.8.0-alpha3 pre
1.8.0-alpha2 pre
1.8.0-alpha1 pre
1.7.0 minor
1.7.0-rcfinal pre
1.7.0-rc9 pre
1.7.0-rc8 pre
1.7.0-rc7 pre
1.7.0-rc6 pre
1.7.0-rc5 pre
1.7.0-rc4 pre
1.7.0-rc3 pre
1.7.0-rc2 pre
1.7.0-rc1 pre
1.6.1-beta3 pre
1.6.1-beta2 pre
1.6.1-alpha4 pre
1.6.1-alpha3 pre
1.6.1-alpha2 pre
1.6.1-alpha pre
1.6.0 initial
1.6.0-rc1 pre
1.6.0-preview5 pre
1.6.0-preview4 pre
1.5.0-rc pre
0.1.0-preview pre