<?xml version="1.0" encoding="utf-8"?>

<packages>

  <package id="ExcelDataReader" version="3.4.2" targetFramework="net45" />

</packages>

using System;

using System.Collections.Generic;

using System.IO;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

namespace ExcelLineReader

{

    class Program

    {

        static void Main(string[] args)

        {

            Console.WriteLine("Please Input Folder Path:");

            var folder = Console.ReadLine();

            var excels = Directory.GetFiles(folder, "*.xlsx", SearchOption.AllDirectories);

            long totalRow = ;

            foreach (var xlsx in excels)

            {

                using (Stream stream = File.OpenRead(xlsx))

                {

                    var reader = ExcelDataReader.ExcelReaderFactory.CreateOpenXmlReader(stream);

                    var rowCount = reader.RowCount - ;

                    Console.WriteLine($"File:{xlsx} Count:{rowCount}");

                    totalRow += rowCount;

                    reader.Close();

                }

            }

            Console.WriteLine("All files Count:" + excels.Length + " All Lines:" + totalRow);

            Console.WriteLine("Press Enter to Exit.");

            Console.ReadKey();

        }

    }

}