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