Custom data mapper about sheettoobjects HOT 12 CLOSED

private Func<string, T> _valueMapper;

var result = new SheetMapper()
                .AddConfigFor<ModelThree>(cfg => cfg
                    .HasHeaders()
                    .MapColumn(column => column
                        .WithColumnIndex(0)
                        .WithDefaultValue(false)
                        .WithValueMapper(x => x == "1" ? true : false)                        
                        .MapTo(t => t.IsMedical))
                    .MapColumn(column => column
                        .WithColumnIndex(1)
                        .MapTo(t => t.Code))
                    .MapColumn(column => column
                        .WithColumnIndex(2)
                        .WithDefaultValue(ProductType.Unknown)
                        .WithValueMapper(x =>
                        {
                            switch(x.ToLower())
                            {
                                case "cheap": return ProductType.Cheap;
                                case "expensive": return ProductType.Expensive;
                                default: return ProductType.Unknown;
                            }
                        })
                        .MapTo(t => t.ProductType)))
                .Map<ModelThree>(sheetData);

if(columnMapping.ValueMapper != null)
                            {   
                                if (property.PropertyType == typeof(string))
                                {
                                    string typedValue = (string)columnMapping.ValueMapper(value.ToString());
                                    property.SetValue(obj, typedValue);
                                }
                                else
                                {
                                    var typedValue = Activator.CreateInstance(property.PropertyType);
                                    typedValue = Convert.ChangeType(columnMapping.ValueMapper(value.ToString()), value.GetType());
                                    property.SetValue(obj, typedValue);
                                }
                            }   
                            else
                            {
                                property.SetValue(obj, value);
                            }

.MapColumn(column => 
                        column.WithHeader("IngredientRatioKgPerTon")
                            .ParseValueUsing(x => !string.IsNullOrEmpty(x) ? double.Parse(x) : 0)
                            .WithDefaultValue(0)
                            .MapTo(m => m.IngredientRatioKgPerTon))

.MapColumn(column => column.WithHeader("IngredientCode").MapTo(m => m.IngredientCode))

if (propertyType.IsNotNullable()
                && propertyType.IsValueType
                && !hasRequiredRule
                && _defaultValue.IsNull())
            {
                throw new MappingConfigurationException(
                    $"Non-nullable property '{propertyInfo.Name}' is not required and therefor needs a default value.");
            }