private void btnImport_Click(object sender, EventArgs e)
{
string sheetPath = txbExcelPath.Text;
string sheetName = textSheetName.Text;
DataTable dt = new DataTable();
ExcelImport excelImport = new ExcelImport();
dt = excelImport.FillDataFromExcelSheet(sheetPath, sheetName);
//This loop Removes Null Or Empty DatatableRows
for (int i = dt.Rows.Count - 1; i >= 0; i--)
{
if (dt.Rows[i][1] == DBNull.Value)
{
dt.Rows[i].Delete();
}
}
dt.AcceptChanges();
dataGridView1.DataSource = dt;
}
