using System;

using System.Collections;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.IO;

using System.Data;

using System.ComponentModel.DataAnnotations;

using System.Globalization;

using System.Reflection;

using System.Collections.ObjectModel;

​

using NUnit.Framework; // Throws NUnit.Framework.AssertionException

​

using CsvHelper;

using CsvHelper.Configuration;

using CsvHelper.Configuration.Attributes;

using CsvHelper.Expressions;

using CsvHelper.TypeConversion;

​

using Newtonsoft.Json;

​

//https://stackoverflow.com/questions/39641220/how-to-read-a-header-from-a-specific-line-with-csvhelper

​

    class TestClass

    {

        public static void Test()

        {

            var csvText = "some crap line\n\nCOL1,COL2,COl3\nval1,val2,val3\nval1,val2,val3\n\n";

            using var stream = new MemoryStream(Encoding.UTF8.GetBytes(csvText));

​

            bool ignoreBlankLines = false;

            var csvConfiguration = new CsvConfiguration(CultureInfo.InvariantCulture)

            {

                IgnoreBlankLines = false,

                ShouldSkipRecord = (args) => !ignoreBlankLines ? false : args.Record.Length == 0 || args.Record.Length == 1 && string.IsNullOrEmpty(args.Record[0]),

                // Your settings here.

            };

            using (var csv = new CsvReader(new StreamReader(stream), csvConfiguration))

            {

                csv.Read(); // Read in the first row "some crap line"

                csv.Read(); // Read in the second empty row, which is empty.

                csv.Read(); // Read in the third row which is the actual header.

                csv.ReadHeader(); // Process the currently read row as the header.

                ignoreBlankLines = true; // Now that the header has been read, ignore blank data lines.

​

                Assert.AreEqual(3, csv.HeaderRecord.Length);

                Assert.AreEqual(@"COL1,COL2,COl3", String.Join(",", csv.HeaderRecord));

​

                Console.WriteLine($"csv.HeaderRecord.Length = {csv.HeaderRecord.Length}: \"{String.Join(",", csv.HeaderRecord)}\"");

                int count = 0;

                while (csv.Read())

                {

                    Console.WriteLine($"  csv.Parser.Count={csv.Parser.Count}");

                    count++;

                }

                Console.WriteLine("Read {0} rows", count);

                Assert.AreEqual(2, count);

​

                Console.WriteLine($"csvConfiguration.IgnoreBlankLines={csvConfiguration.IgnoreBlankLines}");

            }

        }

    }

​

    public class Program

    {

        public static void Main()

        {

            Console.WriteLine("Environment version: {0} ({1})", System.Runtime.InteropServices.RuntimeInformation.FrameworkDescription , GetNetCoreVersion());

            Console.WriteLine("OS Version: {0}, NewLine: {1}", System.Environment.OSVersion, JsonConvert.SerializeObject(Environment.NewLine));

            Console.WriteLine("{0} version: {1}", typeof(CsvReader).Assembly.GetName().Name,  typeof(CsvReader).Assembly.FullName);

            Console.WriteLine();

​

            try

            {

                TestClass.Test();

            }

            catch (Exception ex)

            {

                Console.WriteLine("Failed with unhandled exception: ");

                Console.WriteLine(ex);

                throw;

            }

        }

        public static string GetNetCoreVersion()

        {

            //https://techblog.dorogin.com/how-to-detect-net-core-version-in-runtime-ecd65ad695be

            //

            var assembly = typeof(System.Runtime.GCSettings).GetTypeInfo().Assembly;

            var assemblyPath = assembly.Location.Split(new[] { '/', '\\' }, StringSplitOptions.RemoveEmptyEntries);

            int netCoreAppIndex = Array.IndexOf(assemblyPath, "Microsoft.NETCore.App");

            if (netCoreAppIndex > 0 && netCoreAppIndex < assemblyPath.Length - 2)

                return assemblyPath[netCoreAppIndex + 1];

            return null;

        }

    }

​