Select Code to Download

                            if(decode('cp1252',$oWkC->{Val}) eq "Confi
+gurator mapping")
...
                                for (my $iR = $oWkS->{MinRow} +1; defi
+ned $oWkS->{MaxRow} && $iR <= $oWkS->{MaxRow} ; $iR++)

                                                if(defined $market_cel
+l_name and defined $market_cell and length(decode('cp1252',$market_ce
...
                                                    }
                                                }
                                        }

                    my $market_Cmin = -1;
                    my $market_Cmax = -1;
...
                    
                    for (my $iC = $oWkS->{MinCol}; defined $oWkS->{Max
+Col} && $iC <= $oWkS->{MaxCol} ; $iC++)

        } elsif(decode('cp1252',$oWkC->{Val}) eq "Market"){
                                foreach my $area ( @{ $oWkS->{MergedAr
+ea} } ) {
...
                                }
                                $brand_Cmin = $iC;
                            }

        for(my $iR = $title_row +1; defined $oWkS->{MaxRow} && $iR <= 
+$oWkS->{MaxRow} ; $iR++){
                            $internal_cell = $oWkS->{Cells}[$iR][$map_
+Cmin];
                            $active_cell = $oWkS->{Cells}[$iR][$active
+_col];
                            $family_cell = $oWkS->{Cells}[$iR][$active
+_col];

        $oWkC = $oWkS->{Cells}[$oWkS->{MinRow}][$iC];
                        if(defined $oWkC)
                        {
                            if(decode('cp1252',$oWkC->{Val}) eq "Confi
+gurator mapping")
                            {

    my $map_Cmin = -1; # the first is internal
                    my $map_Cmax = -1;
...
                    my $market_Cmin = -1;
                    my $market_Cmax = -1;
                    my $title_row = -1;

        #set Brands
                                    if($brand_Cmin gt 0 and $brand_Cma
+x gt 0)
...
                                        my $brand_string = "";
                                        my $ignored_brand_string = "";
                                        for(my $brandC = $brand_Cmin; 
+$brandC <= $brand_Cmax ; $brandC++)

        #set Brands
                                    if($brand_Cmin gt 0 and $brand_Cma
+x gt 0)
...
                                                }
                                            }
                                        }

            if(length($brand_string) gt 0){
                                            $materialmapping_item2->se
+tAttribute('brand',$brand_string);
...
                                        if(length($ignored_brand_strin
+g) gt 0){
                                            $materialmapping_item2->se
+tAttribute('ignore_brand',$ignored_brand_string);
                                        }