How to create an Excel file from XML in the Receiver File Adapter Comm Ch

[Former Member]

How do I create an Excel file from XML in the Receiver File Adapter Communication Channel? I have my mapping done and I am outputting the file as a comma delimited csv file. However, the target can only process an Excel file (.xls). How can I generate an Excel in XI?

I saw this blog, but I don't know how to create a XSLT transformation.

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

Any help would be appreciated. Thanks.

[prateek]

The xsl code is provided in the blog. Just copy the code in a notepad and save it with .xsl extension. Zip it with some names and import it under Imported Archives in IR. Then simply use it in interface mapping.

Regards,

Prateek

[Former Member]

How do I incorporate my current mapping into the XSLT?

[Former Member]

Here are the steps I took to create an XSLT transformation in XI 3.0:

1. I created my source and target XSDs using XMLSpy.

2. I created the XSLT mapping from source to target in XMLSpy (referencing the souce XSD schema).

3. I created another XSLT mapping to format the target into Excel XML.

4. Import the source and target XSDs in the IR's External Definitions

5. Zip each XSLT mapping (.xls) and import it into the IR's Imported Archives

6. Reference the XSL mappings in the Interface Mapping