Namespace question

[Sandeep Advani]

Hello

I am trying to convert XML returned from Microsoft spreadsheet object into a smaller XML by applying XSL transformation.

XML:

 
<?xml version="1.0" encoding="ISO-8859-1"?>
<ss:Workbook xmlns:ss="urn:schemas-microsoft-com :-o	 ffice:spreadsheet"> 
                            
  <ss:Worksheet ss:Name="Sheet1" ss :-P	 rotected="1">
    <ss:Table ss:ExpandedColumnCount="20" ss:ExpandedRowCount="10002" ss :mrgreen: efaultColumnWidth="48.0" ss :mrgreen: efaultRowHeight="12.75">
      <ss:Row>
        <ss:Cell/>
        <ss:Cell/>
        <ss:Cell>
          <ss :mrgreen: ata ss:Type="String">PA251</ss :mrgreen: ata>
        </ss:Cell>
        <ss:Cell/>
        <ss:Cell>
          <ss :mrgreen: ata ss:Type="String">PHONE NUMBER</ss :mrgreen: ata>
        </ss:Cell>
      </ss:Row>
    </ss:Table>
  </ss:Worksheet>
</ss:Workbook>
 

In the process to extract selected data and create a much smaller XML, my output does not produce anything. XSLT written by me as follows:

  
<xsl:stylesheet version="1.0"
     xmlns:myss="urn:schemas-microsoft-com :-o	 ffice:spreadsheet"
     xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
 
<xsl :-o	 utput method="xml" version="1.0" encoding="ISO-8859-1" indent="yes" omit-xml-declaration="yes"/>
 
<xsl:template match="myss:Row">
  <xsl:variable name="curNode" select="."/>  
  <xsl:if test="position() > 1 and string-length(normalize-space($curNode)) > 0">     
    <xsl:element name="R">
      <xsl:apply-templates select="myss:Cell"/>
    </xsl:element>
  </xsl:if>  
</xsl:template>
 
<xsl:template match="myss:Cell">
  <xsl:choose>
    <xsl:when test="position() = 1">
      <xsl:element name="C">
        <xsl:apply-templates select="myss :mrgreen: ata"/>
      </xsl:element>    
    </xsl:when> 
    <xsl:when test="position() > 2 and position() < 25">
      <xsl:element name="C">
        <xsl:apply-templates select="myss :mrgreen: ata"/>
      </xsl:element>    
    </xsl:when>
  </xsl:choose>
</xsl:template>
 
<xsl:template match="myss :mrgreen: ata">
  <xsl:apply-templates />
</xsl:template>
 
<xsl:template match="*"/>
</xsl:stylesheet>

Any pointers on what possibly might be wrong here which reasons out on not producing any data back?

Sandeep

[Sandeep Advani]

Kindly ignore the smileys
The big grin is ": D"

[Sandeep Advani]

Updated XML and XSL are as follows. Just realized that there were typos in the prev print....my apologies.

XSL:

  
<?xml version="1.0" encoding="ISO-8859-1" ?> 
<xsl:stylesheet version="1.0"
     xmlns:myss="urn:schemas-microsoft-com :-o	 ffice:spreadsheet"
     xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
 
<xsl :-o	 utput method="xml" version="1.0" encoding="ISO-8859-1" indent="yes"/>
 
<xsl:template match="myss: Row">
  <xsl:element name="R">
    <xsl:apply-templates select="myss: Cell"/>
  </xsl:element>  
</xsl:template>
 
<xsl:template match="myss: Cell">
  <xsl:choose>
    <xsl:when test="position() > 2 and position() < 25">
      <xsl:element name="C">
        <xsl:apply-templates select="myss: Data"/>
      </xsl:element>    
    </xsl:when>
  </xsl:choose>
</xsl:template>
 
<xsl:template match="myss: Data">
  <xsl:apply-templates />
</xsl:template>
 
</xsl:stylesheet>

XML:

 
<?xml version="1.0" encoding="ISO-8859-1"?>
<ss:Workbook xmlns :-o	 ="urn:schemas-microsoft-com :-o	 ffice :-o	 ffice" 
              xmlns:x="urn:schemas-microsoft-com :-o	 ffice:excel" 
              xmlns:ss="urn:schemas-microsoft-com :-o	 ffice:spreadsheet" 
              xmlns:c="urn:schemas-microsoft-com :-o	 ffice:component:spreadsheet" 
              xmlns:html="http://www.w3.org/TR/REC-html40">
              
  <ss:Worksheet ss:Name="Sheet1" ss :-P	 rotected="1">
    <ss:Table ss:ExpandedColumnCount="20" ss:ExpandedRowCount="10002" ss :mrgreen: efaultColumnWidth="48.0" ss :mrgreen: efaultRowHeight="12.75">
      <ss:Column ss:Span="1" ss:Hidden="1" ss:Width="0.0"/>
      <ss:Column ss:Width="72.75"/>
      <ss:Column ss:Width="23.25"/>
      <ss:Column ss:Width="63.75"/>
      <ss:Column ss:Width="62.25"/>
      <ss:Column ss:Width="66.0"/>
      <ss:Column ss:Width="51.75"/>
      <ss:Column ss:Width="90.0"/>
      <ss:Column ss:Width="53.25"/>
      <ss:Column ss:Width="70.5"/>
      <ss:Column ss:Width="77.25"/>
      <ss:Column ss:Width="93.75"/>
      <ss:Column ss:Width="40.5"/>
      <ss:Column ss:Width="51.0"/>
      <ss:Column ss:Width="54.75"/>
      <ss:Column ss:Width="78.75"/>
      <ss:Column ss:Width="78.0"/>
      <ss:Column ss:Width="90.75"/>
      <ss:Column/>
      <ss:Row ss:Height="15.0">
        <ss:Cell>
          <ss :mrgreen: ata ss:Type="String">ERR</ss: Data>
        </ss:Cell>
        <ss:Cell ss:StyleID="wc0981FB6C">
          <ss :mrgreen: ata ss:Type="String">a</ss: Data>
        </ss:Cell>
        <ss:Cell>
          <ss: Data ss:Type="String">Account Number</ss: Data>
        </ss:Cell>
        <ss:Cell>
          <ss: Data ss:Type="String">BTN</ss: Data>
        </ss:Cell>
        <ss:Cell>
          <ss: Data ss:Type="String">Inventory Type</ss: Data>
        </ss:Cell>
        <ss:Cell>
          <ss: Data ss:Type="String">Inventory Item</ss: Data>
        </ss:Cell>
        <ss:Cell>
          <ss: Data ss:Type="String">Product Family</ss: Data>
        </ss:Cell>
        <ss:Cell>
          <ss: Data ss:Type="String">Description</ss: Data>
        </ss:Cell>
        <ss:Cell>
          <ss: Data ss:Type="String">Long Distance Usage</ss: Data>
        </ss:Cell>
        <ss:Cell>
          <ss: Data ss:Type="String">Local Usage</ss: Data>
        </ss:Cell>
        <ss:Cell>
          <ss: Data ss:Type="String">Monthly Charge</ss: Data>
        </ss:Cell>
        <ss:Cell>
          <ss: Data ss:Type="String">One Time Charge</ss: Data>
        </ss:Cell>
        <ss:Cell>
          <ss: Data ss:Type="String">Fed/State/Local Taxes</ss: Data>
        </ss:Cell>
        <ss:Cell>
          <ss: Data ss:Type="String">Discount</ss: Data>
        </ss:Cell>
        <ss:Cell>
          <ss: Data ss:Type="String">Adjustment</ss: Data>
        </ss:Cell>
        <ss:Cell>
          <ss: Data ss:Type="String">Other Taxes</ss: Data>
        </ss:Cell>
        <ss:Cell>
          <ss: Data ss:Type="String">Duration: minutes</ss: Data>
        </ss:Cell>
        <ss:Cell>
          <ss: Data ss:Type="String">Duration: seconds</ss: Data>
        </ss:Cell>
        <ss:Cell>
          <ss: Data ss:Type="String">G/L Account Number</ss: Data>
        </ss:Cell>
        <ss:Cell/>
      </ss:Row>
      <ss:Row>
        <ss:Cell/>
        <ss:Cell/>
        <ss:Cell>
          <ss: Data ss:Type="String">PA251</ss: Data>
        </ss:Cell>
        <ss:Cell/>
        <ss:Cell>
          <ss: Data ss:Type="String">PHONE NUMBER</ss: Data>
        </ss:Cell>
        <ss:Cell>
          <ss: Data ss:Type="String">PAPITT41264403501111111</ss: Data>
        </ss:Cell>
        <ss:Cell/>
        <ss:Cell>
          <ss: Data ss:Type="String">CTXSTD</ss: Data>
        </ss:Cell>
        <ss:Cell>
          <ss: Data ss:Type="Number">0</ss: Data>
        </ss:Cell>
        <ss:Cell>
          <ss: Data ss:Type="Number">0</ss: Data>
        </ss:Cell>
        <ss:Cell>
          <ss: Data ss:Type="Number">50</ss: Data>
        </ss:Cell>
        <ss:Cell>
          <ss :mrgreen: ata ss:Type="Number">0</ss :mrgreen: ata>
        </ss:Cell>
        <ss:Cell>
          <ss: Data ss:Type="Number">0</ss: Data>
        </ss:Cell>
        <ss:Cell>
          <ss: Data ss:Type="Number">0</ss: Data>
        </ss:Cell>
        <ss:Cell>
          <ss: Data ss:Type="Number">0</ss: Data>
        </ss:Cell>
        <ss:Cell>
          <ss: Data ss:Type="Number">0</ss: Data>
        </ss:Cell>
        <ss:Cell>
          <ss: Data ss:Type="Number">0</ss: Data>
        </ss:Cell>
        <ss:Cell>
          <ss: Data ss:Type="Number">0</ss: Data>
        </ss:Cell>
        <ss:Cell/>
        <ss:Cell/>
      </ss:Row>
    </ss:Table>
  </ss:Worksheet>
</ss:Workbook>
 

Question: Would like to know the reason why it does not enter the templates? Output appears all the text data which is printed due to built-in templates behavior.

Thanks
Sandeep

[Sandeep Advani]

Guess I will start a newer and cleaner thread assuming people are ignoring due to 2 replies attached already.