1 CSV file output containing different sheets

[Former Member]

Hi all,

I am required to output a csv file using XI. Input comes from SRM (textfile), output must be CSV. I have searched SDN and found no answers to csv outputs. I need to output the header part in one sheet of the csv then the line items in the succeeding sheets of the CSV file. Is this possible? I tried using an XML output, but CLM (E-Sourcing) is not accepting it. I'm getting different kinds of errors and warnings. Please help.

Thanks!

Regards,

IX

[Former Member · Accepted solution]

Please, check this:

Excel Files - How to handle them in SAP XI/PI (The Alternatives):

/people/shabarish.vijayakumar/blog/2009/04/05/excel-files--how-to-handle-them-in-sap-xipi-the-alternatives

Br,

Dzmitry

[Former Member]

Also check this:

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

And basic approach of working with XLS file:

Read Excel instead of XML through FileAdapter

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

Any case to aim your goal (XLS several sheets output) you have to work with developer or familiar with XSLT specialist.

BR,

Dzmitry

[Former Member]

Hello,

Unfortunately CSV files do not support several sheets (only one). For your requirements you should use XLS file. But no standard functionality to work with XLS files in XI so you need to develop function module and use it in receiver file adapter (there are a lot of templates of working with XLS file from XI on SDN).

BR,

Dzmitry

[Former Member]

is there a standard function module that I can use to output in xls file?

[Former Member]

Hi,

I do not think plain CSV files can have sheets ... They usually contain only "flat" lines with values separated by ";" or "," ... Sheets are saved in XLS files !

Are you sure about this sheet requirement ?

Rgds

Chris