public void Import_fails_for_file_with_missing_worksheet()
        {
            var fileName = $"{_testDataLocation}UKRLP-missing-worksheet.xlsx";

            var reader = GetTestDataStreamReader(fileName);

            var importer = new UkrlpDataImporter(new TestDataRepository(_config, _repoLogger.Object), _importLogger.Object);

            var result = importer.ImportUkrlpData(reader).GetAwaiter().GetResult();

            result.Should().BeFalse();
        }
        public void Import_succeeds_for_valid_file()
        {
            var fileName = $"{_testDataLocation}UKRLP.xlsx";

            var reader = GetTestDataStreamReader(fileName);

            var importer = new UkrlpDataImporter(new TestDataRepository(_config, _repoLogger.Object), _importLogger.Object);

            var result = importer.ImportUkrlpData(reader).GetAwaiter().GetResult();

            result.Should().BeTrue();
        }