title: how to transform plm xml into excel using xslt
body: <p>Plm xml code I exported from teamcenter structure manager is here</p>
  
  <pre><code>&lt;?xml version="1.0" encoding="utf-8"?&gt;
  &lt;?xml-stylesheet type="text/xsl" href="check_new.xsl"?&gt;
  &lt;!-- GENERATED BY: PLM XML SDK 7.0.3.285 --&gt;
  &lt;PLMXML xmlns="http://www.plmxml.org/Schemas/PLMXMLSchema"
   schemaVersion="6" language="en-us" date="2014-12-30" time="18:11:34" author="Teamcenter V10000.1.0.20130604.00 - infodba@IMC--1989821519(-1989821519)"&gt;
  &lt;Header id="id1" traverseRootRefs="#id7" transferContext="new_transfermode"&gt;&lt;/Header&gt;
  &lt;RevisionRule id="id2" name="Latest Working"&gt;
  &lt;Description&gt;Latest Working else Latest Any Status&lt;/Description&gt;
  &lt;ApplicationRef version="QEaRaYqhYa1ubA" application="Teamcenter" label="QEaRaYqhYa1ubA"&gt;&lt;/ApplicationRef&gt;&lt;/RevisionRule&gt;
  &lt;ProductView id="id4" ruleRefs="#id2" rootRefs="id7" primaryOccurrenceRef="id7"&gt;
  &lt;ApplicationRef application="Teamcenter" label="QvfRqkT9Ya1ubA/QEaRaYqhYa1ubA/AAAAAAAAAAAAAA/BOM"&gt;&lt;/ApplicationRef&gt;
  &lt;UserData id="id3" type="TC Specific Properties"&gt;
  &lt;UserValue value="imprecise" title="BOM_precision_type"&gt;&lt;/UserValue&gt;&lt;/UserData&gt;
  &lt;Occurrence id="id7" occurrenceRefs="id11 id15"&gt;
  &lt;ApplicationRef application="Teamcenter" label="QvfRqkT9Ya1ubA/"&gt;&lt;/ApplicationRef&gt;
  &lt;UserData id="id6"&gt;
  &lt;UserValue value="" title="bl_quantity"&gt;&lt;/UserValue&gt;&lt;/UserData&gt;
  &lt;UserData id="id8" type="AttributesInContext"&gt;
  &lt;UserValue value="" title="AO_ID"&gt;&lt;/UserValue&gt;
  &lt;UserValue value="" title="SequenceNumber"&gt;&lt;/UserValue&gt;
  &lt;UserValue value="" title="OccurrenceName"&gt;&lt;/UserValue&gt;
  &lt;UserValue value="" title="Quantity"&gt;&lt;/UserValue&gt;&lt;/UserData&gt;
  &lt;Transform id="id5"&gt;1 0 0 0 0 1 0 0 0 0 1 0 0 0 0 1&lt;/Transform&gt;&lt;/Occurrence&gt;
  &lt;Occurrence id="id11" parentRef="#id7"&gt;
  &lt;ApplicationRef application="Teamcenter" label="QvfRqkT9Ya1ubA/Q3YRqkT9Ya1ubA/"&gt;&lt;/ApplicationRef&gt;
  &lt;UserData id="id10"&gt;
  &lt;UserValue **value="10"** title="bl_quantity"&gt;&lt;/UserValue&gt;&lt;/UserData&gt;
  &lt;UserData id="id12" type="AttributesInContext"&gt;
  &lt;UserValue value="" title="AO_ID"&gt;&lt;/UserValue&gt;
  &lt;UserValue value="10" title="SequenceNumber"&gt;&lt;/UserValue&gt;
  &lt;UserValue value="" title="OccurrenceName"&gt;&lt;/UserValue&gt;
  &lt;UserValue value="10" title="Quantity"&gt;&lt;/UserValue&gt;&lt;/UserData&gt;
  &lt;Transform id="id9"&gt;1 0 0 0 0 1 0 0 0 0 1 0 0 0 0 1&lt;/Transform&gt;&lt;/Occurrence&gt;
  &lt;Occurrence id="id15" parentRef="#id7"&gt;
  &lt;ApplicationRef application="Teamcenter" label="QvfRqkT9Ya1ubA/gTVRqkT9Ya1ubA/"&gt;&lt;/ApplicationRef&gt;
  &lt;UserData id="id14"&gt;
  &lt;UserValue **value="15"** title="bl_quantity"&gt;&lt;/UserValue&gt;&lt;/UserData&gt;
  &lt;UserData id="id16" type="AttributesInContext"&gt;
  &lt;UserValue value="" title="AO_ID"&gt;&lt;/UserValue&gt;
  &lt;UserValue value="20" title="SequenceNumber"&gt;&lt;/UserValue&gt;
  &lt;UserValue value="" title="OccurrenceName"&gt;&lt;/UserValue&gt;
  &lt;UserValue value="15" title="Quantity"&gt;&lt;/UserValue&gt;&lt;/UserData&gt;
  &lt;Transform id="id13"&gt;1 0 0 0 0 1 0 0 0 0 1 0 0 0 0 1&lt;/Transform&gt;&lt;/Occurrence&gt;&lt;/ProductView&gt;&lt;/PLMXML&gt;
  </code></pre>
  
  <p>xsl code:</p>
  
  <pre><code>&lt;?xml version="1.0"?&gt;
  &lt;xsl:stylesheet version="1.0"
             xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
             xmlns:plm="http://www.plmxml.org/Schemas/PLMXMLSchema"
             xmlns="urn:schemas-microsoft-com:office:spreadsheet"
             xmlns:o="urn:schemas-microsoft-com:office:office"
             xmlns:x="urn:schemas-microsoft-com:office:excel"
             xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet"
             xmlns:html="http://www.w3.org/TR/REC-html40" &gt;
    &lt;xsl:output method="html" indent="yes"/&gt;
    &lt;xsl:template match="/"&gt;
      &lt;html&gt;
        &lt;head&gt;
          &lt;title&gt;Admin - Item Ownership&lt;/title&gt;
        &lt;/head&gt;
        &lt;body BGCOLOR="#FFFFFF" link="#0000FF" vlink="#660066"&gt;
          &lt;table&gt;
            &lt;tr align="center" bgcolor="#B8CFEP"&gt;
              &lt;!-- 1st row --&gt;
              &lt;th&gt;part a&lt;/th&gt;         
            &lt;/tr&gt;
         &lt;tr&gt;
        &lt;td&gt;
          &lt;xsl:value-of select="/plm:PLMXML/plm:Header/plm:ProductView/plm:UserData/plm:UserValue/title=bl_quantity"/&gt;
        &lt;/td&gt; &lt;/tr&gt;
          &lt;/table&gt;
        &lt;/body&gt;
      &lt;/html&gt;
    &lt;/xsl:template&gt;
  &lt;/xsl:stylesheet&gt;
  </code></pre>
  
  <p>I need to display values 10 and 15(bl_quantity) in excel sheet. But am not getting any output. Is the syntax of value-of select is right?</p>