public void SkiperAuto() { int countShouldBe = 4; using (var memstream = new MemoryStream()) { var book = new XlBook(); XlSheet sheet = book.AddSheet("test"); int skip = rnd.Next(4) + 1; for (int i = 0; i < skip; i++) { sheet.AddCell($"Caption{i + 1}", $"A{i + 1}", XlContentType.SharedString); } sheet.AddCell("Поле 1", $"A{++skip}", XlContentType.SharedString); sheet.AddCell("Какая-то дата", $"B{skip}", XlContentType.SharedString); sheet.AddCell("Мультизагаловок1", $"C{skip}", XlContentType.SharedString); sheet.AddCell("дробь", $"E{skip}", XlContentType.SharedString); for (int i = ++skip; i < skip + countShouldBe; i++) { sheet.AddCell(i, $"A{i}", XlContentType.Integer); sheet.AddCell(DateTime.Now, $"B{i}", XlContentType.Date); sheet.AddCell($"Какая-то строка{i}", $"C{i}", XlContentType.SharedString); sheet.AddCell($"0.1{i}", $"E{i}", XlContentType.Double); } XlConverter.FromBook(book).SaveToStream(memstream); XLOCReader convertor = XlConverter.FromStream(memstream, new XLOCConfiguration { SkipMode = SkipModeEnum.Auto, SkipCount = 1 }); Assert.AreEqual(countShouldBe, convertor.ReadToArray <TestExcelClass>().Count()); } }
public void SkiperManual() { int countShouldBe = 4; using (var memstream = new MemoryStream()) { var book = new XlBook(); XlSheet sheet = book.AddSheet("test"); sheet.AddCell("Caption", "A1", XlContentType.SharedString); sheet.AddCell("Caption2", "A2", XlContentType.SharedString); sheet.AddCell("Поле 1", "A3", XlContentType.SharedString); sheet.AddCell("Какая-то дата", "B3", XlContentType.SharedString); sheet.AddCell("Мультизагаловок2", "D3", XlContentType.SharedString); sheet.AddCell("дробь", "E3", XlContentType.SharedString); for (int i = 4; i < 4 + countShouldBe; i++) { sheet.AddCell(i, $"A{i}", XlContentType.Integer); sheet.AddCell(DateTime.Now, $"B{i}", XlContentType.Date); sheet.AddCell($"Какая-то строка{i}", $"C{i}", XlContentType.SharedString); sheet.AddCell($"0.1{i}", $"E{i}", XlContentType.Double); } XlConverter.FromBook(book).SaveToStream(memstream); XLOCReader convertor = XlConverter.FromStream(memstream, new XLOCConfiguration { SkipMode = SkipModeEnum.Manual, SkipCount = 2 }); Assert.AreEqual(countShouldBe, convertor.ReadToArray <TestExcelClass>().Count()); } }