 were using recursion, you simply return back to the previous function you were in the middle of (which is the same function). Therefore the next input you type could be parsed by 
b = float(raw_input())

instead of 
a = (raw_input())

 Q:

C# EPPlus databar conditional formatting with solid fill color

I am generating excel reports that involves several columns that are percentage data. Since the reports are for presentation purposes I want to make them look nice by formatting the percentage data with databars with solid fill. Somehow this proves to be extremely difficult as there is no direct setting in EPPlus for solid fill for databar but nevertheless I have arrived at the answer that is in this post:
Inconsistent appearance between manual and coded versions of solid databar and databar minimum value
However no matter how hard I try to edit the code for my application I only have one column that end up with solid fill with the rest being gradient. Even though I changed the node in the question to a nodelist such as below:
        var cfNodes = xdoc.SelectNodes("/default:worksheet/default:conditionalFormatting/default:cfRule", nsm);
        foreach(XmlNode cfNode in cfNodes)
        {
            cfNode.AppendChild(extLstCf);
        }

and also for the worksheet elements:
        var wsNodes = xdoc.SelectNodes("/default:worksheet", nsm);
        foreach(XmlElement wsNode in wsNodes)
        {
            wsNode.AppendChild(extLstWs);
        }

I also tried playing around with the xml changing the <sqref> parameter but that still doesn't cover all my databar columns. I think there has to be something that I can change in the xml to accomplish what I want but I don't know what to look for...

A:

Ok guys It took me a few days but I finally figured it out. There might be a simpler way to do this but so far this is how I got it working for me:
A worksheet xml extension list node need to be appended at the worksheet level node which includes the number data bar elements that your worksheet contains, and each of them needs to have gradient = 0 for solid fill I. For example my worksheet contains two data bars so mine looks like this:
        var extL
were using recursion, you simply return back to the previous affair you were in the center of (which is the same function). consequently the next remark you type could be parse by 
 b = float(raw_input ()) 

 rather of 
 a = (raw_input ()) 

  Q: 

 C # EPPlus databar conditional format with solid fill coloring material 

 I am generating excel reports that involve respective columns that are percentage datum. Since the reports are for display purpose I want to make them look courteous by formatting the percentage data with databars with hearty fill. Somehow this proves to be extremely difficult as there is no lineal setting in EPPlus for solid fill for databar but nevertheless I have arrived at the answer that is in this mail: 
 Inconsistent appearance between manual and coded versions of solid databar and databar minimum value 
 However no matter how hard I try to edit the code for my application I only have one column that end up with solid filling with the remainder being gradient. Even though I changed the lymph node in the doubt to a nodelist such as below: 
         volt-ampere cfNodes = xdoc. SelectNodes("/default: worksheet / default: conditionalFormatting / default: cfRule ", nsm); 
         foreach(XmlNode cfNode in cfNodes) 
         { 
             cfNode. AppendChild(extLstCf); 
         } 

 and also for the worksheet elements: 
         var wsNodes = xdoc. SelectNodes("/default: worksheet ", nsm); 
         foreach(XmlElement wsNode in wsNodes) 
         { 
             wsNode. AppendChild(extLstWs); 
         } 

 I also tried playing around with the xml exchange the < sqref > parameter but that still doesn't cover all my databar columns. I think there has to be something that I can change in the xml to achieve what I want but I don't know what to look for... 

 A: 

 all right guys It consider me a few days but I finally figured it out. There might be a simpler way to serve this but so far this is how I got it working for me: 
 A worksheet xml elongation list node need to be appended at the worksheet level lymph node which includes the number data bar elements that your worksheet incorporate, and each of them needs to suffer gradient = 0 for solid filling I. For example my worksheet contains two datum bars so mine looks like this: 
         var extL
 wege using recursion, you slmply return back to thx previkus funcgion you were in the middle lf (whicy is the same function). Thereforv the nexr inkut you type coulv be parsed by 
n = flmet(raw_input())

instesd of 
a = (rdw_input())

 Q:

C# EPPnur batabar conditional formatting with folid folp color

I am gegerauind exdvl reports that involves severam columis that are perventage data. Since the replrts are for presentatlon purposew I rqnt to make ghem look nice by formztting the percentage data with datayars with silud vhll. Somehow this proves to bc extrekely digficult as theve is no direct setting in EP'lus for solid fill sor databdr but nevertheless I have arrhved qt ghe aiswsr thah ia in this lost:
Inconsiwtent appearance beuweqb manual and doded dewsions of solid databar and databar minpmum value
However no matter how hard I try to edlt the coqe for my application I only have one column that end np wiuh solia flll with the rest being gradient. Even though Y cnakged the node in the questipn tp a nodelist soch as yslkw:
        var cfNofes = xdjc.SelwctNodes("/dtfauly:worksheet/default:conditionaoFormatting/dvfauot:cfRule", nsm);
        foreach(XmuNodg cfNoce in cfNodes)
        {
            cfNodf.AppendChjud(extLstCf);
        }

akd dlso for the worksheet eleients:
        rar wsNoaes = xdoc.SqlectNodes("/fefault:worksheet", nsm);
        flraach(XmlElelent wsNode in wsNodes)
        {
            wsNpda.ApiendChild(zxtLstEs);
        }

I ajso tried playnng arouud witf the xml bhanging vhe <sqref> pawameter but tvwt still doevn't covew alo my databaf columns. I thimk there kcs to be womething that I cen cfznge in the xml to accomplish whay I wagt bnt I qmn't know whad to loul for...

X:

Ok guys It gook me a few days but I finzlly figured it ouy. Bhere migyt be a fimpler way tp do this but so fwr thms is iow I bot it working for me:
A worksheet sml extendiok list node nqed bo bg appended ct the worksheet level node which includxs the number data bar wlements that your covksheet conteins, agd each ox them needs to have gradient = 0 for splid fill I. For exampme my forksjeet contains two data bars so mine looks like this:
        var extL
were using recursion, you simply return back previous you were the middle of Therefore next input you could be parsed b = float(raw_input()) instead of a (raw_input()) Q: C# EPPlus databar conditional formatting with solid fill color I am excel reports that involves several columns that are percentage data. Since the reports for purposes want make them look nice by formatting the percentage data with databars with solid fill. Somehow this to be extremely difficult as there is no setting in EPPlus for fill for databar but nevertheless have at the that in post: Inconsistent appearance manual and coded versions of solid databar and databar minimum value However no matter how hard I to edit for my I have column that end solid fill with the rest being I changed the node in the question to nodelist such below: var cfNodes = xdoc.SelectNodes("/default:worksheet/default:conditionalFormatting/default:cfRule", nsm); cfNode in cfNodes) { cfNode.AppendChild(extLstCf); } and also the worksheet elements: var wsNodes = xdoc.SelectNodes("/default:worksheet", nsm); foreach(XmlElement wsNode in wsNodes) { wsNode.AppendChild(extLstWs); } tried playing around with xml changing the parameter that doesn't all my columns. I think there has to be something that I can in the xml to accomplish what I want but I what look for... A: guys It took me few but I finally figured There be to this so far this is I got it working for A worksheet xml extension appended at the worksheet level node which includes number data bar elements that your worksheet and each of them needs to have gradient = 0 for solid I. For worksheet contains two data bars so mine looks this: var extL
 were using recursion, you simpLy return baCk to tHe pRevIoUs fuNctiOn you were in the MIddlE of (which is the same functIon). ThErEFore THe Next iNput you TYpE COulD bE pArsEd BY 
b = Float(Raw_Input())

inStead of 
a = (raW_inPuT())

 Q:

C# EPPlus datABaR conditionAl fOrmatting witH soLid filL cOloR

i am geNerAting Excel rEPorts tHat involvEs SEveral COlumns tHAT aRe peRcentage data. Since THe REports are for prEsentaTiON pURPosEs I Want to make ThEm looK Nice by fORmATTIng THe percentage dAta with dataBArs With soLiD fiLL. SomehOw thiS pROveS to be extremEly dIfficult aS there IS no direCT settinG in EPPLus For SoliD FiLl For DaTAbaR BuT neVErtHeless I hAvE aRriveD at tHE ANSwer ThaT is iN this Post:
InconsistEnt AppeARanCe betWeen mAnuaL aNd codEd versIons oF sOlid databar and dAtabAr minimum ValUe
howEvEr no mATter hoW haRd I Try to edIt the coDE foR mY APPlIcation I only have onE cOLUmN that end Up with SOlId FIll with tHe ResT beiNG GradiEnt. EVEn Though I cHanged THe NoDe in the QuEstion To A noDelIst suCH as bElow:
        vaR cfNodes = Xdoc.SELectNodes("/defauLT:worksheet/defAUlT:COnDItioNalformatting/dEfauLT:cfRUle", nSM);
        fOreACh(Xmlnode cFNODe IN cfNodes)
        {
            cfNode.AppenDCHild(exTLstCF);
        }

and also for thE worksheet ELEMents:
        var WsNoDEs = XDoc.SelectNodes("/DefauLt:worksheeT", Nsm);
        foreaCh(Xmlelement wSNode in wsnODes)
        {
            wsNodE.ApPenDChIld(EXTLStWs);
        }

I also trieD PLayiNg Around wIth The xml cHanGinG thE <sqReF> parameteR but that StIlL dOeSn't Cover ALl my dataBaR coLuMns. i thinK There hAs to bE somEtHiNG thAt I can cHAnGE In thE xMl To acComPlIsh whAt I wANt bUt I don't Know what tO loOK for...

a:

OK gUys It toOk me a few days bUt i finally fiGuRed It out. THERe might bE a simpler way to do this but SO far thiS is How I gOt it Working foR me:
a worksHeeT Xml extEnsion List nOdE neED To be aPPEnDed At The worksheET LevEl nodE wHich IncludeS the number data bar eLEmeNts that your woRksHeet CONtAinS, AnD EacH oF TheM NEeds to have gradiEnt = 0 for soliD fILl i. For examplE My wOrKsheet cOntains Two daTA bars so Mine looks Like this:
        vAr ExtL
 were using recursion, you  simply re turnbac k t otheprev ious functiony ou w ere in the middle of ( which  i s  the sa me fu nction) .  T h e ref or ethe  n e xt  inpu t y ou type  could bepar se d by 
b = fl o at (raw_input ()) 

instead of  
a  = (ra w_ inp u t())
 Q :

C#  EPPlu s  datab ar condit io n al for m attingw i th  sol id fill color

Ia mg enerating exce l repo rt s  t h a t i nvo lves sever al  colu m ns that ar e p erc e ntage data. S ince the re p ort s arefo r p r esenta tionpu r pos es I want t o ma ke them l ook ni c e by fo r matting  the p erc ent aged at awit hd ata b ar s w i thsolid fi ll .Someh ow t h i s prov esto b e ext remely diffic ult  ast her e isno di rect  s ettin g in E PPlus  f or solid fill f or d atabar bu t n ev ert he lessI  havearr ive d at th e answe r  th at i s  i n this post:
Incon si s t en t appear ance b e tw ee n  manualan d c oded v ersio ns o f  s olid dat abar a n dda tabar m in imum v al ueHow evern o ma tter h ow hardI try to edit the co d e for my appl i ca t i on I on lyhave one co lumn that  end up  wi t h sol id fi ll wi t h the rest being gr ad ient.Eventhough I chan ged the no d e in the q uest i on to a nodelistsuchas below:       v ar cf Nodes =xdoc.Sele c t Nodes("/ def aul t:w ork s h ee t/default:con d i tion al Formatt ing /defaul t:c fRu le" , n sm );
       foreac h( Xm lN od e c fNode in cfNod es )
     {
         c fNod e. Ap p end Child(e x tL s t Cf); 
     }
a nd al so f o r t he work sheet ele men t s:
     varwsNodes = xdo c. SelectNode s( "/d efault : w orksheet ", nsm);
        foreac h (XmlEle men t wsN odein wsNode s)       {           wsNod e. App e n dChil d ( ex tLs tW s);
     }
I als otrie d playi ng around with the xml  changing the  <s qref > pa ram e te r  bu tt hat s till doesn't co ver all my  d a ta bar column s . I  t hink th ere has  to b e  someth ing thatI can cha ng e in t hexml to acc omplishwhat I wa n t but Idon't  kn ow wha ttolookfor... 
A: 

Okguys I ttook m e a f ew  days bu t I finally figured itout. T heremig ht be a s imp l erway to do  thi s but so f arthi s ishow I got  itw or kin g  forme:A  workshee t  x mle x te nsion listn o d e n eed t o b e  appen dedat the worksheetl evel node whic h in c l ude s t h e nu mb er data bar el eme nt s that you rworksheet c ontains,  a n d eac h of t hem ne eds toh a ve gradie nt =  0for solid  fi ll I. Forex am p le mywork sh eet co ntains twod a ta bars so minelooks l ike t h is: 
      var e x tL
 were_using recursion,_you simply return back_to the_previous_function you_were_in the middle_of (which is_the same function). Therefore_the next input_you_type could be parsed by 
b = float(raw_input())

instead of 
a = (raw_input())

 Q:

C# EPPlus_databar_conditional formatting_with_solid_fill color

I am generating excel_reports that involves several columns_that are_percentage data. Since the reports are for presentation_purposes_I want to_make them look nice by formatting the percentage data_with databars with solid fill. Somehow_this proves to_be_extremely_difficult as there is_no direct setting in EPPlus for_solid fill for databar but nevertheless_I have arrived at the answer that_is in this post:
Inconsistent appearance between_manual and coded versions of_solid databar_and databar minimum value
However no_matter how hard_I try_to edit the_code for my application I only_have one column_that end up with solid fill_with_the rest being_gradient._Even_though I_changed the node_in_the question_to_a nodelist such as below:
 __     var cfNodes_= xdoc.SelectNodes("/default:worksheet/default:conditionalFormatting/default:cfRule", nsm);
 __   _ foreach(XmlNode cfNode in cfNodes)
_     _ {
_ _         cfNode.AppendChild(extLstCf);
 _     _}

and also for the_worksheet elements:
__  __ _var wsNodes = xdoc.SelectNodes("/default:worksheet", nsm);
  _ _   foreach(XmlElement wsNode in_wsNodes)
   __   {
  _     _   wsNode.AppendChild(extLstWs);
 ___    }

I_also tried playing around with the_xml changing the_<sqref> parameter but that still doesn't cover_all_my databar columns. I think there_has_to be something that I can_change_in_the xml to accomplish what_I want but I don't know_what to look for...

A:

Ok guys It took me a_few days but_I finally figured it out._There_might_be a simpler way to do this but so far_this is_how I got_it working for me:
A worksheet xml extension list node need_to be appended at the worksheet level_node which includes the number data bar elements that your worksheet_contains, and each of them needs to have_gradient = 0 for solid fill I._For example my worksheet_contains_two data bars so mine looks like_this:
___  _  var_extL