A BenchmarkDotNet extension to export benchmark results as xlsx file.

BenchmarkDotNetXlsxExporter is a .NET Standard 2.0 library.

Install the nuget package BenchmarkDotNetXlsxExporter by adding a PackageReference:

<PackageReference Include="BenchmarkDotNetXlsxExporter" Version="1.0.0" />

Platform Support

• .NET Core 2.0, 3.0, 3.1
• .NET Framework 4.6.1
• Mono 5.4
• Xamarin.iOS 10.14
• Xamarin.Mac 3.8
• Xamarin.Android 8.0
• Universal Windows Platform 10.0.16299

To enable the exporter, add the attribute XlsxExporterAttribute to the benchmark class:

using System;
using System.Security.Cryptography;
using BenchmarkDotNet.Attributes;
using BenchmarkDotNet.Exporters.Xlsx;
using BenchmarkDotNet.Jobs;
using BenchmarkDotNet.Running;

public class Program
{
    [MemoryDiagnoser, SimpleJob(RuntimeMoniker.NetCoreApp31), SimpleJob(RuntimeMoniker.Net48), XlsxExporter]
    public class Md5VsSha256
    {
        private const int N = 10000;
        private readonly byte[] data;

        private readonly SHA256 sha256 = SHA256.Create();
        private readonly MD5 md5 = MD5.Create();

        public Md5VsSha256()
        {
            data = new byte[N];
            new Random(42).NextBytes(data);
        }

        [Benchmark]
        public byte[] Sha256() => sha256.ComputeHash(data);

        [Benchmark]
        public byte[] Md5() => md5.ComputeHash(data);
    }

    public static void Main(string[] args)
    {
        BenchmarkRunner.Run(typeof(Program).Assembly);
    }
}

For custom configurations of the XlsxExporter add it to the exporter list (without the attribute).

public class Program
{
    [MemoryDiagnoser, SimpleJob(RuntimeMoniker.NetCoreApp31), SimpleJob(RuntimeMoniker.Net48)]
    public class Md5VsSha256
    {
        // omitted, see above.
    }

    public static void Main(string[] args)
    {
        var xlsxExporter = new XlsxExporter();
        BenchmarkRunner.Run(typeof(Program).Assembly, DefaultConfig.Instance.AddExporter(xlsxExporter));

        // or a minimal xlsx output:
        // BenchmarkRunner.Run(typeof(Program).Assembly, DefaultConfig.Instance.AddExporter(XlsxExporter.MinimalXlsxHandlers));
    }
}

A example of the exporter output: ConsoleApp.MyBenchmarks.Md5VsSha256-report.xlsx.

Feel free to do pull requests for any kind of improvements, ask questions or just :star this repository when you find it useful.

The solution BenchmarkDotNetXlsxExporter has three projects.

Core

BenchmarkDotNet.Exporters.Xlsx contains the core functionality, the exporter.

Tests

BenchmarkDotNet.Exporters.Xlsx.Tests contains unit tests.

Console App

ConsoleApp is an example/playground how the exporter can be used.

Unit Testing is done with xUnit.

Code coverage is done with Coverlet.

Code coverage reports is done with ReportGenerator.

Code Coverage statistic

Executing unit tests will trigger code coverage and report generation.

The code coverage result is stored in .\artifacts\tests\coverage (format is OpenCover).

The graphical code coverage reports are stored in .\artifacts\tests\coverage\reports and history in .\artifacts\tests\coverage\reports\history.

The project separates the three concerns Building, Testing and Packaging. All of these steps could be executed individually.

BuildTestPack.ps1

This command calls internally Build.ps1, Test.ps1 and Pack.ps1 and supports following parameters:

Build.ps1

Builds all projects. Supports the Configuration parameter.

Test.ps1

Runs all tests. Supports Configuration, CollectCoverage, NoIntegrationTests and NoBuild parameters.

Pack.ps1

Creates the nuget packages into the .\artifacts\packages directory. Supports Configuration and NoBuild parameters.