private void btnImport_Click(object sender, EventArgs e)
{
ResetGrid();
OpenFileDialog o = new OpenFileDialog();
o.Filter = "CSV files (*.csv)|*.csv|Excel Files|*.xls;*.xlsx";
if (o.ShowDialog() == DialogResult.OK)
{
string filename = o.FileName;
string ext = Path.GetExtension(filename);
DataTable dt = new DataTable();
switch (ext)
{
case ".csv":
dt = FileParser.DataTableFromCSV(filename);
break;
case ".xls":
dt = FileParser.DataTableFromXlsx(filename);
break;
case "xlsx":
dt = FileParser.DataTableFromXlsx(filename);
break;
}
dgvData.DataSource = dt;
}
dgvData.CellValueChanged -= dgvData_CellValueChanged;
dgvData.CellValueChanged += dgvData_CellValueChanged;
}