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