public void Setup()
{
using (var memory = new MemoryStream(ExcelFiles.FirstSample))
{
var header = new HeaderDefinition<FirstSampleData>();
header.Skip(2);
header.Register(x => x.ColunaC).Formatter("pt-BR");
header.Register(x => x.ColunaD);
header.Register(x => x.ColunaE);
data = WorkbookReader.Create(header)
.Read(new HSSFWorkbook(memory));
}
}
public void Setup()
{
using (var memory = new MemoryStream(ExcelFiles.SamplePALM))
{
var header = new HeaderDefinition<Sample>();
header.Skip(28);
header.Register(x => x.DateProp);
header.SkippingRows(7);
data = WorkbookReader.Create(header)
.Read(new HSSFWorkbook(memory));
}
}
public void CanStopWhenNoMoreLinesFound()
{
using (var memory = new MemoryStream(ExcelFiles.MultiSheetsSample))
{
var header = new HeaderDefinition<FirstSampleData>();
header.Skip(2);
header.Register(x => x.ColunaC).Formatter("pt-BR");
var data = WorkbookReader.Create(header, 2)
.Read(new HSSFWorkbook(memory))["TestD"];
data.Records.Count().Should().Be(0);
}
}
public void CanGetFormattingErrors()
{
using (var memory = new MemoryStream(ExcelFiles.FirstSample))
{
var header = new HeaderDefinition<FirstSampleData>();
header.Skip(2);
header.Register(x => x.ColunaC).Formatter("en-US");
var data = WorkbookReader.Create(header)
.Read(new HSSFWorkbook(memory))[0];
data.Records.Count().Should().Be(4);
data.Errors.Count().Should().Be(4);
data.Errors.Select(x => x.Column).Should().Have.SameSequenceAs(2, 2, 2, 2);
}
}
public void CanGetNonNullableColumnsError()
{
using (var memory = new MemoryStream(ExcelFiles.MultiSheetsSample))
{
var header = new HeaderDefinition<FirstSampleData>();
header.Skip(2);
header.Register(x => x.ColunaC).Formatter("pt-BR");
var data = WorkbookReader.Create(header)
.Read(new HSSFWorkbook(memory))[1];
data.Records.Count().Should().Be(4);
data.Errors.Count().Should().Be(1);
data.Errors.Select(x => x.Column).Should().Have.SameSequenceAs(2);
data.Errors.Select(x => x.Row).Should().Have.SameSequenceAs(3);
}
}
private static HeaderDefinition<NullableData> CreateHeader()
{
var header = new HeaderDefinition<NullableData>();
header.Register(x => x.ColunaA).Named("A");
header.Register(x => x.ColunaB).Named("B");
header.Register(x => x.ColunaC).Formatter("pt-BR");
header.Register(x => x.ColunaD).Named("D");
header.Register(x => x.ColunaE);
return header;
}
private static HeaderDefinition<NullableData> CreateHeader()
{
var header = new HeaderDefinition<NullableData>();
header.Register(x => x.ColunaA).Named("A");
header.Register(x => x.ColunaD).Named("D");
header.Register(x => x.GetWhatever()[1].ToString()).Named("H");
header.Register(x => x.GetWhatever()[3].ToString()).Named("I");
return header;
}
private static HeaderDefinition<BasicData> CreateHeader()
{
var header = new HeaderDefinition<BasicData>();
header.Register(x => x.ColunaA).Named("A");
header.Skip(1);
header.Register(x => x.ColunaC).Formatter("pt-BR");
header.Skip(1);
header.Register(x => x.ColunaE);
header.SkippingRows(4);
return header;
}
