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);
}
