XSLT Mapping for creating Excel files

[Former Member]

Hi ,

I am following the blog /people/michal.krawczyk2/blog/2005/12/10/xi-generating-excel-files-without-the-java-nor-the-conversion-agent-not-possible by Michal regarding conversion of Flat files to Excel file format.

My input xml format is

<?xml version="1.0" encoding="utf-8"?>

<FILE>

<Record>

<Name>Navin</Name>

<EmpID>123456</EmpID>

<Location>Bangalore</Location>

</Record>

<Record>

<Name>Ravi</Name>

<EmpID>789456</EmpID>

<Location>Hyderabad</Location>

</Record>

</FILE>

i need to convert this file into an Excel format with each record in single rows with Column Header names as Name,EmpID,Location.

Could you please suggest how the XLST mapping should be done for this as i am very new to XSLT mapping concept.

Please suggest how we can attain the target structure(datatype) and steps to do this XSLT mapping.

Note:- We are not doing Adapter module for this conversion.

Thanks,

Navin

[Shabarish_Nair]

why dont you try the java api. its much flexible and simpler to use - /people/shabarish.vijayakumar/blog/2009/04/05/excel-files--how-to-handle-them-in-sap-xipi-the-alternatives

[stefan_grube]

> i need to convert this file into an Excel format with each record in single rows with Column Header names as Name,EmpID,Location.

This can be done with file content convertion. Use delimiter ; for excel

> Could you please suggest how the XLST mapping should be done for this as i am very new to XSLT mapping concept.

If you do not understand XSLT, you you want to maintain your development, in case if an error?

http://w3schools.com/xsl/default.asp

[Former Member]

Hi Stefan,

i hope FCC can used with delimiter as comma so that we can generate a .csv file.The .csv file will open in excel format.

But my requirement is that i need to generate .xls file with Header names in Columnwise as i mentioned in the initial post.

Navin