Exemplo n.º 1
0
        static async Task Main()
        {
            //EPPlus
            var EPPlus = new EPPlus();
            await EPPlus.ReadDataAsync();

            await EPPlus.WriteDataAsync();

            Console.WriteLine("EPPlus Read/Write complete...");

            //NPOI

            //ExcelDataReader


            //BenchmarkDotNet

#if (!Debug)
            var summary = BenchmarkRunner.Run(typeof(Program).Assembly);
#endif

            return;
        }
Exemplo n.º 2
0
        static async Task Main()
        {
#if (Debug)
            string memoryUsage = "";
            WriteLine(memoryUsage.GetLowDetailAboutMemoryUsage());
            var watch = Stopwatch.StartNew();

            #region EPPlus

            var epplus = new EPPlus();
            WriteLine("EPPlus Processes Starting...");

            WriteLine("Read Method Started...");
            await epplus.ReadDataAsync();

            WriteLine("Read Method Complete...");
            WriteLine(memoryUsage.GetLowDetailAboutMemoryUsage() + "\n");

            WriteLine("Write Method Started...");
            await epplus.WriteDataAsync();

            WriteLine("Write Method Complete...");
            WriteLine(memoryUsage.GetLowDetailAboutMemoryUsage() + "\n");

            watch.Stop();
            WriteLine("EPPlus Processes Complete...");
            WriteLine($"Execution Time: {watch.ElapsedMilliseconds} milliseconds or around {watch.Elapsed.TotalSeconds} seconds. \n");
            #endregion

            #region NPOI
            watch.Reset();
            watch.Start();

            var NPOI = new NPOI();
            WriteLine("NPOI Processes Starting...");

            WriteLine("Read Method Started...");
            await NPOI.ImportDataAsync();

            WriteLine("Read Method Complete...");
            WriteLine(memoryUsage.GetLowDetailAboutMemoryUsage() + "\n");

            WriteLine("Write Method Started...");
            await NPOI.WriteDataAsync();

            WriteLine("Write Method Complete...");
            WriteLine(memoryUsage.GetLowDetailAboutMemoryUsage() + "\n");

            watch.Stop();
            WriteLine("NPOI Processes Complete...");
            WriteLine($"Execution Time: {watch.ElapsedMilliseconds} milliseconds or around {watch.Elapsed.TotalSeconds} seconds. \n");
            #endregion

            #region ExcelDataReader and ClosedXML Writer
            watch.Reset();
            watch.Start();

            var ExcelDR = new ExcelDataReaderAndClosedXMLWriter();
            WriteLine("ExcelDataReader / ClosedXML Writer Processes Started...");

            WriteLine("Read Method Started...");
            await ExcelDR.ReadExcelDataAsync();

            WriteLine("Read Method Complete...");
            WriteLine(memoryUsage.GetLowDetailAboutMemoryUsage() + "\n");

            WriteLine("Write Method Started...");
            await ExcelDR.WriteClosedXMLDataAsync();

            WriteLine("Write Complete Method...");
            WriteLine(memoryUsage.GetLowDetailAboutMemoryUsage() + "\n");

            watch.Stop();
            WriteLine("ExcelDataReader / ClosedXML Writer Processes Complete...");
            WriteLine($"Execution Time: {watch.ElapsedMilliseconds} milliseconds or around {watch.Elapsed.TotalSeconds} seconds. \n");
            #endregion

            #region ClosedXML Reader only
            watch.Reset();
            watch.Start();

            var ClosedXML = new ClosedXMLReader();
            WriteLine("ClosedXML Read Data Process Started...");
            ClosedXML.GetDataFromExcel();
            WriteLine("ClosedXML Read Method Complete...");
            WriteLine(memoryUsage.GetLowDetailAboutMemoryUsage() + "\n");

            watch.Stop();
            WriteLine($"Read Process Only - Execution Time: {watch.ElapsedMilliseconds} milliseconds or around {watch.Elapsed.TotalSeconds} seconds. \n");
            #endregion
#endif

#if (!Debug)
            var config = new ManualConfig()
                         .WithOptions(ConfigOptions.DisableOptimizationsValidator)
                         .AddValidator(JitOptimizationsValidator.DontFailOnError)
                         .AddLogger(ConsoleLogger.Default)
                         .AddColumnProvider(DefaultColumnProviders.Instance);

            BenchmarkRunner.Run(typeof(Program).Assembly, config);
#endif

            return;
        }