Verify ClosedXML Workbook

[BermudaLamb]

Is there a verification package that handles ClosedXML Workbooks?

[BermudaLamb]

I've saved the workbook to a file and I'm trying to use the VerifyFile method. However, even though the received and verified files are identical the tool is throwing a verifiedexception.

                var testwb = new XLWorkbook();
                testwb.AddWorksheet();
                var filePath = Path.Combine(TestContext.CurrentContext.WorkDirectory, "ExcelFilter.xlsx");
                testwb.SaveAs(filePath);
                await Verifier.VerifyFile(filePath, _verifySettings, extension: "xlsx")
                    .UseFileName(TestName(TestContext.CurrentContext));
                File.Delete(filePath);

[SimonCropp]

can you share a full example?

[BermudaLamb]

        [Test]
        public async Task TestExcelWorkbook()
        {
            var testwb = new XLWorkbook();
            testwb.AddWorksheet();
            var filePath = Path.Combine(TestContext.CurrentContext.WorkDirectory, "ExcelFilter.xlsx");
            testwb.SaveAs(filePath);
            await Verifier.VerifyFile(filePath, _verifySettings, extension: "xlsx")
                .UseFileName(TestName(TestContext.CurrentContext));
            File.Delete(filePath);
        }

I've also tried to vefiry the workbook as a stream, following the stream / blob example

        [Test]
        public async Task TestExcelWorkbook()
        {
            var testwb = new XLWorkbook();
            testwb.AddWorksheet();
            using (var wbStream = new MemoryStream())
            {
                testwb.SaveAs(wbStream);
                await Verifier.Verify(wbStream, "xlsx", _verifySettings)
                    .UseFileName(TestName(TestContext.CurrentContext) + " AS STREAM");
            }
        }

Even though I saved the received file as the verified file I'm still gettring this exception

    VerifyException : Directory: C:\Git\continuousimprovement\tests\Strata.ContinuousImprovement.Biz.Test.Unit\FreeForm\Opportunities\snapshots
NotEqual:
  - Received: Test Excel Workbook AS STREAM.received.xlsx
    Verified: Test Excel Workbook AS STREAM.verified.xlsx

[BermudaLamb]

I created a private github repo and invited you as a collaborator

[SimonCropp]

u should not need .UseFileName(TestName(TestContext.CurrentContext));. the test name should be derived

[BermudaLamb]

I'm using that to get a better name for the files that our team understands. Also, based on the test patterns, some of the auto-generated names had special characters that our CICD pipeline didn't like.