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