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 Setup()
{
using (var memory = new MemoryStream(ExcelFiles.FirstSample))
{
var header = new HeaderDefinition<BasicData>();
header.Register(x => x.ColunaA);
header.Register(x => x.ColunaB);
header.Register(x => x.ColunaC).Formatter("pt-BR");
header.Register(x => x.ColunaD);
header.Register(x => x.ColunaE);
header.SkippingRows(2);
data = WorkbookReader.Create(header)
.Read(new HSSFWorkbook(memory));
}
}
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;
}
