Skip to Content
avatar image
Former Member

Excel file output from SAP System

Hi All,

I have a requirement to extract data from SAP System and provide excel output (.xls file).

Should I use XI for this scenario. I understand that there are Function Modules in ABAP that can render excel files very easily.

I tried a sample scenario where I used tab as delimiter in Content conversion and gave "a.xls" as filename.The file is rendered and it opens as excel file, but it gives out a warning. I am thinking of not using Modules/Java Map for excel file processing.

Please guide me through the correct design approach.

Regards,

Sudharshan N A

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Aug 01, 2008 at 09:51 AM

    Dear Sudharshan,

    For this purpose we can use

    MessageSwapBean, MessageTransformBean.

    Please search for the same to send get the output as excel file.

    Best Regards

    Praveen

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 01, 2008 at 08:33 AM

    Sudarshan,

    Just taking a wild guess here. Try saving the output file with , as delimiter and the file name with extension .csv By default csv files are rendered using MS excel. But have never attempted this.

    Regards,

    Jaishankar

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      >>What I am concerned that if the customer wants only .xls (Excel File), then what should be the approach.

      Then you can not escape the clutches of Java. Either an adapter module or the mapping is the only solution I could imagine.

      Regards,

      Jaishankar

  • avatar image
    Former Member
    Aug 01, 2008 at 08:13 AM

    Hi Sudharshan,

    if you do not need any mappings, try to find a appropriate RFC that is able to send the rendered xls data in a file.

    In XI so you just have to route the file to the receiver.

    Regards Mario

    Add comment
    10|10000 characters needed characters exceeded