private void OpenDialog(Spreedsheet sprd, Control ctl, string worksheetName = "") { try { if (sprd.OpenFile()) { Spreedsheet = sprd; LoadExcelData(Spreedsheet); ctl.Visible = true; } } catch (Exception e) { ctl.Visible = false; MessageBox.Show(e.Message); } }
// Todo, passar função de validação private void LoadExcelData(Spreedsheet sprd) { try { if (sprd.OpenFile()) { sprd.GetTabelaExcel(); dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells; dataGridView1.DataSource = sprd.DataTable; //lblRegistros.Text = (dgvDados.Rows.Count - 1).ToString(); sprd.DataTable.Dispose(); txtLogo.Visible = false; } else { throw new Exception("Erro a carregar o arquivo"); } } catch (Exception e) { MessageBox.Show(e.Message); } }