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;
}
