Excel-DNA: Test ExcelReference.SetValue performance

SetValuePerf.cs

using System;
using System.Diagnostics;
using ExcelDna.Integration;
using static ExcelDna.Integration.XlCall;

namespace SetValuePerf
{
    public static class Macros
    {

        [ExcelCommand(ShortCut = "^D")] // Ctrl + Shift + D
        public static void DumpValues()
        {
            var numWritesInput = Excel(xlfInput, "Number of writes:", 1, "SetValuePerf Test", 20000);
            if (numWritesInput is bool)
                return;
            var numWrites = Convert.ToInt32(numWritesInput);

            var sw = Stopwatch.StartNew();
            for (int i = 0; i < numWrites; i++)
            {
                var r = new ExcelReference(i, i, 0, 1);
                r.SetValue(new object[,] { { $"Info - {i}", DateTime.Now } });
            }
            sw.Stop();
            new ExcelReference(0, 4).SetValue("Writes / ElapsedMs / Writes per ms:");
            new ExcelReference(0, 0, 5, 7).SetValue(new object[,] { { numWrites, sw.ElapsedMilliseconds, (double)numWrites / sw.ElapsedMilliseconds } });
        }


        [ExcelCommand(ShortCut = "^E")] // Ctrl + Shift + E
        public static void DumpValuesEverywhere()
        {
            var numWritesInput = Excel(xlfInput, "Number of writes:", 1, "SetValuePerf Test", 20000);
            if (numWritesInput is bool)
                return;
            var numWrites = Convert.ToInt32(numWritesInput);

            // Add 9 new sheets, named Sheet2 - Sheet10
            for (int s = 0; s < 9; s++)
            {
                Excel(xlcWorkbookInsert, 1);
            }

            // Scatter some values around the various sheets
            var sw = Stopwatch.StartNew();
            for (int i = 0; i < numWrites; i++)
            {
                var r = new ExcelReference(i/10, i/10, 0, 1, $"Sheet{i%10 + 1}");
                r.SetValue(new object[,] { { $"Info - {i}", DateTime.Now } });
            }
            sw.Stop();
            Excel(xlcWorkbookActivate, "Sheet1");
            new ExcelReference(0, 4).SetValue("Writes / ElapsedMs / Writes per ms:");
            new ExcelReference(0, 0, 5, 7).SetValue(new object[,] { { numWrites, sw.ElapsedMilliseconds, (double)numWrites / sw.ElapsedMilliseconds } });
        }
    }
}