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