private void Initialize() { for (var x = _fromCol; x <= _toCol; x++) { var fieldObj = _dataProvider.GetCellValue(_worksheet, _fieldRow, x); var val = _dataProvider.GetCellValue(_worksheet, _fieldRow + 1, x); if (fieldObj != null && val != null) { if (fieldObj is string) { var field = new ExcelDatabaseCriteriaField(fieldObj.ToString().ToLower(CultureInfo.InvariantCulture)); _criterias.Add(field, val); } else if (ConvertUtil.IsNumeric(fieldObj)) { var field = new ExcelDatabaseCriteriaField((int)fieldObj); _criterias.Add(field, val); } } } }
private void Initialize() { for (var x = _fromCol; x <= _toCol; x++) { var fieldObj = _dataProvider.GetCellValue(_worksheet, _fieldRow, x); var val = _dataProvider.GetCellValue(_worksheet, _fieldRow + 1, x); if (fieldObj != null && val != null) { if(fieldObj is string) { var field = new ExcelDatabaseCriteriaField(fieldObj.ToString().ToLower(CultureInfo.InvariantCulture)); _criterias.Add(field, val); } else if (ConvertUtil.IsNumeric(fieldObj)) { var field = new ExcelDatabaseCriteriaField((int) fieldObj); _criterias.Add(field, val); } } } }