BrowardHealth.EPPlusHelperCore 1.0.0

    static void Main(string[] args)
    {
        string execDir = Path.GetDirectoryName(Assembly.GetExecutingAssembly().Location);
        string inputFileName = "Test.xlsx";
        string inputFilePath = Path.Combine(execDir, inputFileName);

        Console.WriteLine($"{inputFilePath} => DataTable...");
        DataTable dataTable = inputFilePath.EPPlusReadFromExcel();

        string outputFileName = "TestOut.xlsx";

        string outputFilePath = Path.Combine(execDir, outputFileName);
        Console.WriteLine($"DataTable => {outputFilePath}...");
        dataTable.EPPlusWriteExcelFile(outputFilePath);

        // option 1
        Console.WriteLine($"{inputFilePath} => dynamic list...");
        List<dynamic> list1 = inputFilePath.EPPlusReadFromExcel<dynamic>();

        foreach (dynamic row in list1.Take(5))
        {
            Console.WriteLine($"{row.PT_Number}, {row.Admit_Date}");
        }

        // option 2
        Console.WriteLine($"{inputFilePath} => ExpandoObject list...");
        List<ExpandoObject> list2 = inputFilePath.EPPlusReadFromExcel<ExpandoObject>();

        foreach (ExpandoObject eo in list2.Take(5))
        {
            var dict = (IDictionary<string, object>)eo;
            foreach (string key in dict.Keys)
            {
                Console.Write($"{key}, {dict[key]}; ");
            }
            Console.WriteLine();
        }

        // option 3
        Console.WriteLine($"{inputFilePath} => Dictionary list...");
        List<Dictionary<string, object>> list3 = inputFilePath.EPPlusReadFromExcel<Dictionary<string, object>>();

        foreach (var dict in list3.Take(5))
        {
            foreach (KeyValuePair<string, object> pair in dict.ToList())
            {
                Console.Write($"{pair.Key}, {pair.Value}; ");
            }
            Console.WriteLine();
        }


        Console.WriteLine("Enter any key to exit...");

        Console.ReadKey();
    }