Conversion Agent_XmlToExcel

[Former Member]

Hi All,

I am trying to convert Xml to Excel using Conversion Agent. For this i am using a serializer.

Within the ContentSerializer i am using transformers and the processor is XmlToExcel. But this does not work.

The error thrown is :

R403574 Java Error: Failed to call method. Java Exception Message: XmlToExcel failed to process the file

[R303583 org.apache.poi.itemfield.hssf.write.XmlToExcel: function process failed.

How can i make the Conversion Agent work for XmlToExcel conversion?

Alternatively, i tried to use the JExcel API which works well on my machine. But when moved to the PI server (which run JRE 1.4.x), the jxl.jar is not supported. I get an exception that says :

Class has wrong version:50. Should be version 48.

Any idea where i can find jxl.jar compatible with JRE 1.4.x ?

Regards,

Balaji.M

[Former Member]

HI,

I had the same problem.

On the Java Excel API Homepage you can find older version of the API.

This worked for me.

Download:

jexcelapi.sourceforge.net

You may also check other options to generate the Excel File:

http://wiki.sdn.sap.com/wiki/display/ABAP/ExcelwithSAP-An+overview

Best regards,

Markus