xsl-list
[Top] [All Lists]

RE: problem converting xml to excel

2004-03-11 21:51:56
Hi,

My xml file looks like this
      <result>
              <row><col>col1</col><col>col2</col><col/></row>
              
<row><col>col1row2</col><col>col2ro2</col><col>col3row2</col></row>
      </result>
If you see carefully the third column in row1 is empty. This 
is causing a 
problem . Instead of leaving the excel cell empty the cell is 
being filled 
with the first value I enter into excel. If I do not fill in 
row0 col0 what 
ever value I fill in first gets in there. Can someone please 

That's odd, your stylesheets gives me

  <gmr:Cell ValueType="60" Col="1" Row="5">col1</gmr:Cell>
  <gmr:Cell ValueType="60" Col="2" Row="5">col2</gmr:Cell>
  <gmr:Cell ValueType="60" Col="3" Row="5"></gmr:Cell>
  <gmr:Cell ValueType="60" Col="1" Row="6">col1row2</gmr:Cell>
  <gmr:Cell ValueType="60" Col="2" Row="6">col2ro2</gmr:Cell>
  <gmr:Cell ValueType="60" Col="3" Row="6">col3row2</gmr:Cell>

I.e. the cell is empty like it should be.

Cheers,

Jarno

 XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list