Creation of Excel files using XSLT

[former_member203631]

Hi frnds,

From the blog provided by the Michal

/people/michal.krawczyk2/blog/2005/12/10/xi-generating-excel-files-without-the-java-nor-the-conversion-agent-not-possible

I came to know that we can create excel files using XSLT mapping but here inthis blog the example provides creation of only one column but I have a scenario where in I want 3 columns ex:Name,Age,Sex

Shiva 26 Male

Ravi 25 Male

Rani 24 Female

.....

but using the code provided in Michal blog Im getting the output as

Shiva

26

Male

Ravi

25

Male

Rani

24

Female

...

Can anyone help me in modifying the code given in Michal blog to get the output as required.

Please share your ideas or suggestion onthis...

Thanks in advance,

Shiva.

[GabrielSagaya]

Please change the code as

<xsl:template match="file_SDN/recordset/data/*">

<Row>

<Cell>

<Name ss:Type="String">

<xsl:apply-templates/>

</Name>

<Age ss:Type="Integer">

<xsl:apply-templates/>

</Age>

<Sex ss:Type="String">

<xsl:apply-templates/>

</Sex>

</Cell>

</Row>

</xsl:template>