Transformation syntax

ole_geismar2 — Wed, 10 Nov 2021 07:50:02 GMT

I am parsing at table named "header" to the transformation containing all the header information to my list which is built as XML.

Among these tablefields are these two:

"TILGANG" - the heading-text that is to be inserted in each column
"RGB_BACK" - the background-colour-code in RGB format, like "#FFFFFF".

I made a loop where I successfuly insert the header-text, using "value ref" on "tilgang" into the XML-string, but where the colour code (Interior) is fixed:

<tt:loop ref=".header" name="H">
 <Cell ss:StyleID="Hstock">
   <Interior ss:Color="#007A37"/>
   <Data     ss:Type="String"> <tt:value ref="$H.tilgang"/></Data>
 </Cell>
</tt:loop>

But when I try to insert the colour code "rgb_back" in a similar way; I get a syntax error.

<tt:loop ref=".header" name="H">
 <Cell ss:StyleID="Hstock">
   <Interior ss:Color=<tt:value ref="$H.rgb_back"/>/>
   <Data     ss:Type="String"> <tt:value ref="$H.tilgang"/></Data>
 </Cell>
</tt:loop>

Obviously, there is something wrong with the syntax in the "Interior" line, but what?

Re: Transformation syntax

Sandra_Rossi — Wed, 10 Nov 2021 16:04:58 GMT

   <Interior>
     <tt:attribute name="ss:Color" value-ref="$H.rgb_back"/>
   </Interior>

Re: Transformation syntax

ole_geismar2 — Thu, 11 Nov 2021 08:02:51 GMT

Thank you Sandra, That was the push I needed.

topic Re: Transformation syntax in Application Development and Automation Discussions

Transformation syntax

Re: Transformation syntax

Re: Transformation syntax