BrowardHealth.EPPlusHelperCore 1.1.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);


        Console.WriteLine($"{inputFilePath} => DataTable...");
        List<dynamic> list = inputFilePath.EPPlusReadFromExcel<dynamic>();

        string outputFileName1 = "TestOut1.xlsx";

        string outputFilePath1 = Path.Combine(execDir, outputFileName1);
        Console.WriteLine($"List => {outputFilePath1}...");
        list.EPPlusWriteExcelFile(outputFilePath1);


        string inputFileName2 = "Test.csv";
        string outputFileName2 = "TestOut2.xlsx";

        string inputFilePath2 = Path.Combine(execDir, inputFileName2);
        string outputFilePath2 = Path.Combine(execDir, outputFileName2);
        Console.WriteLine($"{inputFilePath2} => {outputFilePath2}...");
        inputFilePath2.EPPlusWriteExcelFile(outputFilePath2
            //, excelTextFormat: null
            , excelTextFormat: new()
            {
                Delimiter = ',',
                SkipLinesEnd = 1,
                TextQualifier = '\"'                   
            }
            );

        string outputFileName3 = "TestOut3.csv";
        string outputFilePath3 = Path.Combine(execDir, outputFileName3);
        Console.WriteLine($"{outputFilePath2} => {outputFilePath3}...");
        outputFilePath2.EPPlusWriteCsvFile(outputFilePath3
            //, excelOutputTextFormat: null
            , excelOutputTextFormat: new()
            {
                Delimiter = ',',
                SkipLinesEnd = 1,
                TextQualifier = '\"',
                FirstRowIsHeader = true
            }
            );


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