private void loadData() { prBar.Visible = true; prBar.Minimum = 2; OpenFileDialog openFileDialog = new OpenFileDialog(); openFileDialog.Filter = "Excel files (*.xls)|*.xls"; openFileDialog.RestoreDirectory = true; openFileDialog.Multiselect = true; MyTable myTable = MyTable.getInstance(); DataTable dt = new DataTable(); for (int i = 0; i < 62; i++ ) dt.Columns.Add(i.ToString()); if (openFileDialog.ShowDialog() == System.Windows.Forms.DialogResult.OK) { foreach (string fileName in openFileDialog.FileNames) { ExcelDoc excelDoc = new ExcelDoc(fileName); prBar.Maximum = excelDoc.getCount("A", 2); prBar.Value = prBar.Minimum; int i = 2; while (excelDoc.getValue("A" + i.ToString(), "A" + i.ToString()) != null) { dt.Rows.Add(excelDoc.getRow(i)); i++; prBar.Value++; } excelDoc.Dispose(); } myTable.loadData(dt); } prBar.Visible = false; prBar.Value = prBar.Minimum; }