stWs = xdoc.CreateNode(XmlNodeType.Element, "extLst", xdoc.DocumentElement.NamespaceURI);
        extLstWs.InnerXml = @"<ext uri=""{78C0D931-6437-407d-A8EE-F0AAD7539E65}"" 
                                        xmlns:x14=""http://schemas.microsoft.com/office/spreadsheetml/2009/9/main"">
                                    <x14:conditionalFormattings>
                                    <x14:conditionalFormatting xmlns:xm=""http://schemas.microsoft.com/office/excel/2006/main"">
                                    <x14:cfRule type=""dataBar"" id=""{3F3F0E19-800E-4C9F-9CAF-1E3CE014ED86}"">
                                        <x14:dataBar minLength=""0"" maxLength=""100"" gradient=""0"">
                                        <x14:cfvo type=""num"">
                                            <xm:f>0</xm:f>
                                        </x14:cfvo>
                                        <x14:cfvo type=""num"">
                                            <xm:f>100</xm:f>
                                        </x14:cfvo>
                                        <x14:negativeFillColor rgb=""FFFF0000""/><x14:axisColor rgb=""FF000000""/>
                                        </x14:dataBar>
                                    </x14:cfRule>
                                    <xm:sqref>A1:A20</xm:sqref>
                                    </x14:conditionalFormatting>
                                    <x14:conditionalFormatting xmlns:xm=""http://schemas.microsoft.com/office/excel/2006/main"">
                                        <x14:cfRule type=""dataBar"" id=""{3F3F0E19-800E-4C9F-9CAF-1E3CE014ED86}"">
                                        <x14:dataBar minLength=""0"" maxLength=""100"" gradient=""0"">
                                            <x14:cfvo type=""num"">
                                            <xm:f>0</xm:f>

stWs = xdoc. CreateNode(XmlNodeType. Element, " extLst ", xdoc. DocumentElement. NamespaceURI); 
         extLstWs. InnerXml = @"<ext uri=""{78C0D931 - 6437 - 407d - A8EE - F0AAD7539E65 } " " 
                                         xmlns: x14=""http://schemas.microsoft.com / office / spreadsheetml/2009/9 / main " " > 
                                     < x14: conditionalFormattings > 
                                     < x14: conditionalFormatting xmlns: xm=""http://schemas.microsoft.com / office / excel/2006 / main " " > 
                                     < x14: cfRule type=""dataBar " " id=""{3F3F0E19 - 800E-4C9F-9CAF-1E3CE014ED86 } " " > 
                                         < x14: dataBar minLength=""0 " " maxLength=""100 " " gradient=""0 " " > 
                                         < x14: cfvo type=""num " " > 
                                             < xm: f>0</xm: f > 
                                         < /x14: cfvo > 
                                         < x14: cfvo type=""num " " > 
                                             < xm: f>100</xm: f > 
                                         < /x14: cfvo > 
                                         < x14: negativeFillColor rgb=""FFFF0000""/><x14: axisColor rgb=""FF000000""/ > 
                                         < /x14: dataBar > 
                                     < /x14: cfRule > 
                                     < xm: sqref > A1: A20</xm: sqref > 
                                     < /x14: conditionalFormatting > 
                                     < x14: conditionalFormatting xmlns: xm=""http://schemas.microsoft.com / office / excel/2006 / chief " " > 
                                         < x14: cfRule type=""dataBar " " id=""{3F3F0E19 - 800E-4C9F-9CAF-1E3CE014ED86 } " " > 
                                         < x14: dataBar minLength=""0 " " maxLength=""100 " " gradient=""0 " " > 
                                             < x14: cfvo type=""num " " > 
                                             < xm: f>0</xm: f >
stWd = xdoc.CreateNode(XmlNodeUype.Element, "extLsj", zdoc.DorumentEmement.NaoespaceURI);
        extLstWs.InierXnl = @"<ezt uri=""{78C0D931-6437-407d-A8EE-F0AAD7539E65}"" 
                                        xmlns:x14=""http://aghemav.nicrosoft.com/ofnice/spreadsveetml/2009/9/main"">
                                    <x14:condityonalFotmwttings>
                                    <x14:conditionalFodmattinj xmlns:xm=""http://scnemas.microsoft.com/office/excfl/2006/maln"">
                                    <x14:cfRule gype=""dataBag"" id=""{3F3F0E19-800E-4C9F-9CZF-1E3CE014ED86}"">
                                        <x14:eatwTar minLengvh=""0"" maxJength=""100"" gradicmt=""0"">
                                        <x14:cfvo type=""nuk"">
                                            <xn:f>0</zm:f>
                                        </s14:cfvo>
                                        <x14:dfvo trpq=""num"">
                                            <xm:f>100</xm:f>
                                        </x14:sfvo>
                                        <x14:negadiveFmluCooov rgc=""DFVF0000""/><x14:axisColor rgb=""FF000000""/>
                                        </x14:dataBcr>
                                    </x14:cyDume>
                                    <xi:sqrrf>A1:A20</xm:sqref>
                                    </x14:conditionapFormatting>
                                    <s14:conditionapFormattihe xmlns:xm=""http://schdmax.mhcrosoft.com/office/excel/2006/main"">
                                        <d14:cfRule type=""dataBar"" id=""{3F3F0F19-800E-4C9F-9CCF-1E3CE014AD86}"">
                                        <x14:dataBar minLgngdh=""0"" kaxLengtk=""100"" gradlent=""0"">
                                            <x14:cfno type=""nuk"">
                                            <vm:f>0</xn:f>

stWs = xdoc.CreateNode(XmlNodeType.Element, "extLst", xdoc.DocumentElement.NamespaceURI); extLstWs.InnerXml = xmlns:x14=""http://schemas.microsoft.com/office/spreadsheetml/2009/9/main""> <x14:conditionalFormatting xmlns:xm=""http://schemas.microsoft.com/office/excel/2006/main""> type=""dataBar"" id=""{3F3F0E19-800E-4C9F-9CAF-1E3CE014ED86}""> <x14:dataBar <xm:f>0</xm:f> <x14:cfvo type=""num""> <xm:f>100</xm:f> <x14:negativeFillColor rgb=""FFFF0000""/><x14:axisColor rgb=""FF000000""/> </x14:cfRule> <xm:sqref>A1:A20</xm:sqref> </x14:conditionalFormatting> <x14:conditionalFormatting xmlns:xm=""http://schemas.microsoft.com/office/excel/2006/main""> <x14:cfRule id=""{3F3F0E19-800E-4C9F-9CAF-1E3CE014ED86}""> <x14:dataBar minLength=""0"" maxLength=""100"" gradient=""0""> <x14:cfvo type=""num""> <xm:f>0</xm:f>
stWs = xdoc.CreateNode(XmlNodetype.ElemenT, "extLSt", xDoc.doCumeNtElEment.NamespaceurI);
        exTLstWs.InnerXml = @"<ext uri=""{78C0D931-6437-407D-A8EE-F0aAd7539e65}"" 
                                        xmlNS:x14=""Http://sChemas.mICrOSOft.CoM/oFfiCe/SPrEadshEetMl/2009/9/main"">
                                    <x14:ConditionaLFoRmAttings>
                                    <x14:condITiOnalFormatTinG xmlns:xm=""http://SchEmas.miCrOsoFT.com/oFfiCe/excEl/2006/main"">
                                    <X14:CfRule Type=""dataBAr"" ID=""{3F3F0E19-800E-4C9f-9cAF-1E3CE014Ed86}"">
                                        <X14:DaTaBaR minLength=""0"" maxLengTH=""100"" gRAdient=""0"">
                                        <x14:cfvo typE=""num"">
                                            <xm:F>0</xM:F>
                                        </x14:CFVo>
                                        <x14:CfvO type=""num"">
                                            <xm:F>100</xM:f>
                                        </x14:cfVO>
                                        <x14:negatIVefILLCoLOr rgb=""FFFF0000""/><x14:axiSColor rgb=""FF000000""/>
                                        </X14:DatABar>
                                    </x14:cFRUle>
                                    <XM:sqref>a1:A20</xm:sQrEF>
                                    </x14:cOnditionalFOrmaTting>
                                    <x14:conDitionALFormatTIng xmlnS:xm=""httP://scHemAs.miCRoSoFt.cOm/OFfiCE/eXceL/2006/MaiN"">
                                        <x14:cfRule TyPe=""DataBAr"" id=""{3f3f0e19-800e-4c9F-9CAf-1E3Ce014ED86}"">
                                        <x14:DataBAr minLength=""0"" maXLeNgth=""100"" GRadIent=""0"">
                                            <x14:Cfvo tYpe=""nUm"">
                                            <Xm:f>0</xm:F>

stWs = xdoc.CreateNode(Xml NodeType.E lemen t,"ex tL st",  xdo c.DocumentElem e nt.N amespaceURI);
       extLs tW s .Inn e rX ml =@"<extu ri = " "{7 8C 0D 931 -6 4 37 -407d -A8 EE-F0AA D7539E65}" "                                   xm lns :x14=" "h ttp : //sch ema s.mic rosoft . com/of fice/spre ad s heetml / 2009/9/ m a in "">                               <x14: co n di t i ona lFo rmattings> 
                         < x14:conditi o nal Format ti ngx mlns:x m=""h tt p :// schemas.mic roso ft.com/of fice/e x cel/200 6 /main"" >
                     <x 14:cfRul ety pe="" data B a r " " id ="" {3F3 F0E19 -800E-4C9F-9C AF- 1E3C E 014 ED86} "">
                                <x14 :dataBarmin Le ngt h= ""0"" maxLen gth ="" 100"" g radient = ""0 "" >                                 < x 14 :c f vo type= "" num "">                               <xm: f> 0</ xm: f>
                                 < / x14:cfvo>
                           <x 1 4: cfv o  type =""nu m" " >                                       <x m:f>100</x m : f >
                                 </x 1 4:cfvo>                                < x14 : n eg ativeFillColo r rgb= "" FFFF000 0"" /><x14: axi sCo lor  rg b= ""FF00000 0""/>
                           </ x 14:dat aBar> 
                      </ x1 4:cfR ule>                             <x m:sqref>A1:A2 0< /xm:sqref> 
                              </x14:c o ndition alF ormat ting >
                             < x1 4:c o n ditio n a lF orm at ting xmlns : x m=" "http :/ /sch emas.mi crosoft.com/office / exc el/2006/main" ">                          < x14:cfRule  t y pe =""dataBar " " i d= ""{3F3F 0E19-80 0E-4C 9 F-9CAF- 1E3CE014E D86}"">
                              <x14: d at aBarmin Length =" "0" " max Length = ""1 00""gradie nt =""0"" >
                                       <x1 4:c fvo type= ""n u m"" >
                                   < x m: f>0 < /xm:f >

stWs =_xdoc.CreateNode(XmlNodeType.Element, "extLst",_xdoc.DocumentElement.NamespaceURI);
   _ __ extLstWs.InnerXml_=_@"<ext uri=""{78C0D931-6437-407d-A8EE-F0AAD7539E65}"" 
_  _   _  __             __ ___    _    xmlns:x14=""http://schemas.microsoft.com/office/spreadsheetml/2009/9/main"">
_ _       __  _        _     _  ___ <x14:conditionalFormattings>
  _     _     _      _     _    _ _ <x14:conditionalFormatting xmlns:xm=""http://schemas.microsoft.com/office/excel/2006/main"">
  _  _ _  _     _  _     __  ___ _  <x14:cfRule_type=""dataBar""_id=""{3F3F0E19-800E-4C9F-9CAF-1E3CE014ED86}"">
 __     __      _   __   _    _     _ _ <x14:dataBar_minLength=""0"" maxLength=""100"" gradient=""0"">
        _     _   _ __  __ _      _ _   <x14:cfvo type=""num"">
 _   __     _     _    ___    _     _  _    <xm:f>0</xm:f>
  __     __     ___    _     _        _ </x14:cfvo>
 _    ___         _ _  _         _      <x14:cfvo_type=""num"">
          _       _      _   __      ____  _<xm:f>100</xm:f>
  _  _ _  _ _  __                 _     </x14:cfvo>
_    __  _   _       _        __ _   _ _<x14:negativeFillColor rgb=""FFFF0000""/><x14:axisColor_rgb=""FF000000""/>
  _ _ _ _      __        ____  _  _  _  </x14:dataBar>
__     _  _   _         _           </x14:cfRule>
     _ _   _ __     _ _       __    <xm:sqref>A1:A20</xm:sqref>
       ___  __     _____     _      </x14:conditionalFormatting>
__    _ __   _   _          __ ____ <x14:conditionalFormatting xmlns:xm=""http://schemas.microsoft.com/office/excel/2006/main"">
 _              __    _     __   _      <x14:cfRule type=""dataBar""_id=""{3F3F0E19-800E-4C9F-9CAF-1E3CE014ED86}"">
    _   _                    _    _    _<x14:dataBar minLength=""0"" maxLength=""100""_gradient=""0"">
_  _   _       _                 _      _  _<x14:cfvo type=""num"">
_        _          _             __     _  <xm:f>0</xm:f>
