xi to excel file

[Former Member]

i need to make a file to file scenario,

the receiving file should be of excel format...

how can i do that

can u help me

[Former Member]

one simple way of doing the same is to generate .csv which gets open in Excel :).

Otherwise we will have to use module programming or as per Michal suggestion.

Regards

Rajeev

[Former Member]

i m not much into j2ee, can u provide a sample code to convert the XML to csv , and how to deploy that ejb developed............

[Former Member]

Hi Sudeep,

You need to create a module processor for writing a file to excel. The module is required to convert the XML from XI to Excel.

For writing the file to Excel, you need to download an API for excel called as POI. the jar files for POI needs to be added in your NWDS. Using the POI API, you can

write files to Excel.

The business logic should be written in an EJB file and you need to follow the rest of steps for creating the module.

http://help.sap.com/saphelp_nw04s/helpdata/en/cd/5af7c0c994e24fb0d0088443513de2/frameset.htm

Also check these helpful threads:

Hope these help

Do get back to me for any other details

Regards

Kiran..

[former_member335553]

Hi

check this blog if th is helps u

<a href="/people/michal.krawczyk2/blog/2005/12/10/xi-generating-excel-files-without-the-java-nor-the-conversion-agent-not-possible Excel files without the Java nor the Conversion agent not possible?</a>