Exemplo n.º 1
0
        private static void Read()
        {
            //var f1 = @"D:\Documents\Tutorials\Microsoft\Common\Excel Import Export\Lib\npoi-master\examples\hssf\ImportXlsToDataTable\xls\Book1.xls";
            //var f2 = @"C:\Users\kha\Desktop\BigFile.xlsx";
            //var f3 = @"C:\Users\kha\Desktop\sample.xls";
            //var f4 = @"C:\Users\kha\Desktop\Blackfire-Stock.xls";
            //var f = @"C:\Users\kha\Desktop\test.xlsx";
            var f = @"C:\Users\kha\Desktop\Classeur1.xlsx";
            var start = DateTime.Now;
            Console.WriteLine("Start reading : " + DateTime.Now);

            //var reader = new Reader();
            //reader.InitializeWorkbook(f5);
            //var list = reader.ConvertToList().Reverse().ToList();
            //foreach (var val in list)
            //{
            //    Console.WriteLine(val);
            //}
            //Console.WriteLine("Total : " + list.Count);
            //Console.WriteLine("Reading finished : " + (DateTime.Now - start));

            var reader = new Reader(f, XlsxReaderType.Epplus);
            var list = reader.ConvertToList();
            Console.WriteLine("file imported: " + list.Count() + " rows at " + (DateTime.Now - start) + ".\n");
        }
Exemplo n.º 2
0
        protected void ImportBtn_Click(object sender, EventArgs e)
        {
            MsgLabel.Text = string.Empty;
            _path = UploadFile();
               var th1 =  new Thread(() =>
               {
                   var start = DateTime.Now;
                   var reader = new Reader(_path.Replace("test", "test1"));
                   var list = reader.ConvertToList();
                   MsgLabel.Text += "Thread file imported: " + list.Count() + " rows at " + (DateTime.Now - start) + ".\n";
                   Debug.WriteLine("thread 1: " + MsgLabel.Text);
               });
            th1.Start();

            th1.Join();
        }
Exemplo n.º 3
0
 private static void ThreadsRead()
 {
     //var f1 = @"D:\Documents\Tutorials\Microsoft\Common\Excel Import Export\Lib\npoi-master\examples\hssf\ImportXlsToDataTable\xls\Book1.xls";
     //var f2 = @"C:\Users\kha\Desktop\BigFile.xlsx";
     //var f3 = @"C:\Users\kha\Desktop\sample.xls";
     //var f4 = @"C:\Users\kha\Desktop\Blackfire-Stock.xls";
     var f = @"C:\Users\kha\Desktop\test.xlsx";
     //var start = DateTime.Now;
     Console.WriteLine("Start reading : " + DateTime.Now);
     var listThs = new List<Thread>();
     for (var i = 1; i < 2; i++)
     {
         listThs.Add(new Thread(() =>
         {
             var start = DateTime.Now;
             var reader = new Reader(f.Replace("test", "Import\\test1"), XlsxReaderType.Npoi);
             var list = reader.ConvertToList();
             Console.WriteLine(string.Format("{0} file imported: {1} rows at {2}.\n",Thread.CurrentThread.Name, list.Count(), (DateTime.Now - start)));
         }) { Name = "Thread " + i });
     }
     foreach (var thread in listThs)
     {
         thread.Start();
     }
     listThs[0].Join();
 }