public void TestExcelWrite() { var serializer = new ExcelSerializer(); serializer.HasHeaderRecord = true; StreamTransport transport = new StreamTransport(); var build = new OutputBuilder() .SetSerializer(serializer) .AddListData(GetTestData()); var dataIntegrator = new Integrator(); var result = dataIntegrator.SendData(build, transport); Stream ResultStream = transport.GetLastRawData(); Assert.True(ResultStream.Length > 0, "Stream cannot be empty"); }
public void TestExcelRead() { List <ExcelTestClass> data = new List <ExcelTestClass>(); var serializer = new ExcelSerializer(); serializer.HasHeaderRecord = true; StreamTransport transport = new StreamTransport(); transport.InputStream = GenerateRawData(); var dataIntegrator = new Integrator(); var build = new InputBuilder() .SetSerializer(serializer) .ReadAll(data); dataIntegrator.ReceiveData(build, transport); Assert.NotNull(data); Assert.Equal(2, data.Count); Assert.Equal("Thomas Jefferson", data[1].Name); Assert.Equal(34.8M, data[0].NetWorth); }