private void MenuFileOpen_Click(object sender, EventArgs e) { if (openFileDialog.ShowDialog(this) == DialogResult.OK) { string filename = openFileDialog.FileName; string extension = Path.GetExtension(filename); if (extension == ".xls" || extension == ".xlsx") { ExcelReader db = new ExcelReader(filename, true, false); TableSelectDialog t = new TableSelectDialog(db.GetWorksheetList()); if (t.ShowDialog(this) == DialogResult.OK) { DataTable table = db.GetWorksheet(t.Selection); this.dgvAnalysisSource.DataSource = table; clbInput.Items.Clear(); clbOutput.Items.Clear(); foreach (DataColumn col in table.Columns) { clbInput.Items.Add(col.ColumnName); clbOutput.Items.Add(col.ColumnName); } } } } }