private static DataTable GetBatchData(IExcelFileReader excelFileReader)
{
// Get batch indicator data from worksheet as data table
DataTable batchDataTable = excelFileReader.GetBatchData();
// Delete non-valid rows
foreach (var row in batchDataTable.Select("IndicatorId is null"))
{
row.Delete();
}
batchDataTable.AcceptChanges();
return batchDataTable;
}
