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; }