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