cancel
Showing results for 
Search instead for 
Did you mean: 

How to convert File to Excel (.xls) format?

Former Member
0 Kudos
53

Hia,

I know we can convert files to Excel and other Structured and Unstructured Formats using Conversion Agent by Itemfield.

What are the other means by which we can convert file to Excel (.xls)?

View Entire Topic
henrique_pinto
Active Contributor
0 Kudos

You can use a Java API for Excel (example: http://jexcelapi.sourceforge.net/), with which you could develop a module to convert from XML to excel.

Regards,

Henrique.

Former Member
0 Kudos

Hi,

As mentioned abouve answer you have to create your own ejb/adapter module. That module can be called in the receiver adapter and convert the XI Payload in

Excel Sheet.

To achive it you have to put some Extra efforts on Java Code whichi will produce Excel SHeet based on your input data:)

Thanks

Farooq.

Former Member
0 Kudos

Thanks a lot guys, but sort of Adapter Module we will use???

does anyone has got some sort of example...or link please

Former Member
Former Member
0 Kudos

Sharma,

Check this weblog where michal have given a simple example with XSLT:

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

If this not fit your requirement then check this out:

/people/sap.user72/blog/2005/07/04/read-excel-instead-of-xml-through-fileadapter

Regards,

---Satish