public void SetProperties() { var builder = new ExcelModelBuilder(); builder.IgnoreSheetNames(); var model = builder.Build(); Assert.AreEqual(true, model.IgnoreSheetNames); }
public void NullResultFromOnReadSheet_Unnamed() { var sheet = workbook.Worksheets.Add("Sheet1"); var builder = new ExcelModelBuilder(); builder.IgnoreSheetNames(); builder.Sheet <Class1>(); var model = builder.Build(); var mock = new Mock <SampleContext>(model); mock.Protected().Setup <object>("OnReadSheet", sheet, model.Sheets[0]).Returns(null).Verifiable(); mock.CallBase = true; var context = mock.Object; Assert.ThrowsException <InvalidOperationException>(() => { var result = context.TestOnReadFile(workbook); }); }
public void MultipleIgnoreNames() { var sheet = workbook.Worksheets.Add("Sheet1"); var sheet2 = workbook.Worksheets.Add("Sheet2"); var builder = new ExcelModelBuilder(); builder.IgnoreSheetNames(); builder.Sheet <Class1>(); builder.Sheet <Class2>(); var model = builder.Build(); var mock = new Mock <SampleContext>(model); mock.Protected().Setup <object>("OnReadSheet", sheet, model.Sheets[0]).Returns(new List <Class1>()).Verifiable(); mock.Protected().Setup <object>("OnReadSheet", sheet2, model.Sheets[1]).Returns(new List <Class2>()).Verifiable(); mock.CallBase = true; var context = mock.Object; var result = context.TestOnReadFile(workbook); Assert.IsNotNull(result); Assert.AreEqual(2, result.Count); Assert.IsInstanceOfType(result[0], typeof(List <Class1>)); Assert.IsInstanceOfType(result[1], typeof(List <Class2>)); mock.Verify(); }