private void LoadExcelData(Spreedsheet sprd, bool planilhaUpdateVisibility = true)
{
sprd.GetTabelaExcel();
lblPlanilhaNomeArquivo.Text = sprd.Title;
slblTpMainEnderecoArquivo.Text = "Arquivo: " + sprd.FileName;
dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells;
dataGridView1.DataSource = sprd.DataTable;
sprd.DataTable.Dispose();
btnPlanilhaUpdate.Visible = planilhaUpdateVisibility;
tabMain.SelectedTab = tpPanilha;
}
// 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);
}
}