private void dataGridView1Load() { try { ExcelOLEDB.ExcelVersion version = (ExcelOLEDB.ExcelVersion) this.comboBoxExcelVersion.SelectedValue; ExcelOLEDB datos = new ExcelOLEDB(this.openFileDialog1.FileName, version); DataTable valores = datos.readExcel(); this.dataGridView1.DataSource = valores; this.dataGridView1.SelectionMode = DataGridViewSelectionMode.FullColumnSelect; } catch (Exception ex) { MessageBox.Show(ex.Message, "Error al leer Excel", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void dataGridView1Load() { try { ExcelOLEDB.ExcelVersion version = (ExcelOLEDB.ExcelVersion)this.comboBoxExcelVersion.SelectedValue; ExcelOLEDB datos = new ExcelOLEDB(this.openFileDialog1.FileName, version); DataTable valores = datos.readExcel(); this.dataGridView1.DataSource = valores; this.dataGridView1.SelectionMode = DataGridViewSelectionMode.FullColumnSelect; } catch (Exception ex) { MessageBox.Show(ex.Message, "Error al leer Excel", MessageBoxButtons.OK, MessageBoxIcon.Error); } }