Skip to Content
0
Former Member
Jun 22, 2010 at 07:08 AM

XSLT Mapping for creating Excel files

28 Views

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