getting output in xls format

[Former Member]

hi, can anybody tell me how to get the output in xls format

[Former Member]

Hi,

Check some links.

excel files

SAP Network Blog: XI: Generating Excel files without the Java nor the Conversion agent not possible?

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

SAP Network Blog: Read Excel instead of XML through FileAdapter

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

Regards,

Phani

[Former Member]

Hi Murty,

Do you mean Excel format? If the output format you need isn't very complicated (just a header row and data rows) you can generate the output as CSV. You can open CSV file format with Excel.

If you need to generate formatted excel output, I think this Weblog could help you:

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

Regards,

Gari.

[Former Member]

Hi,

In XI all the Message processing is by-default with XML format.

If you can explain your scenario the we could narrow down the preciseness for the suggestions.

When you work with HTTP adapter by-default the output format will be inXML format.

If you are dealing with file adapter then you have to use Message Protocall as "File" it will process the data in xml format.

Even with SOAP adapter you will get data in XML format.

Thanks

Swarup

Edited by: Swarup Sawant on Feb 22, 2008 8:30 AM

[Former Member]

Hi Murty,

where??

Can u plz explain ur scenarion in detail?

Thanks,

maheshwari

[Former Member]

hi, while using file adapter , can i get the output in xls format.

[Former Member]

hi, while using file adapter , can i get the output in xls format.

[Former Member]

yes you can get the XMl output with file adapter.

While configuring the file adapter in communciation channel use Message Protocall as "File" and give some target fiel name as XXX.xls

The Message protocall with file will give the xls output as it is without any conversions.

Thanks

swarup

Edited by: Swarup Sawant on Feb 22, 2008 8:44 AM

[Former Member]

Hi ,

I think if you are looking for integrating Excel to XI, then I will suggest to not consider the my above post.

I am sorry for the confusion. I am interpreted it as xml .....

Please refer below post for Excel to XI

Read Excel instead of XML through FileAdapter

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

SAP Network Blog: eMail Report as Attachment (Excel/Word)

/people/community.user/blog/2006/09/08/email-report-as-attachment-excelword

SAP Network Blog: XI: Generating Excel files without the Java nor the Conversion agent not possible?

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

SAP Network Blog: How to send any data (even binary) through XI, without using the Integration Repository

/people/william.li/blog/2006/09/08/how-to-send-any-data-even-binary-through-xi-without-using-the-integration-repository

Thanks

Swarup