Skip to Content
avatar image
Former Member

Reading an Excel ZIP Attachment from an Mail and Send it to ECC AL11 path.

Hi All,

Can some one please explain the steps involved in Reading an Excel ZIP Attachment from an Mail and Send it to ECC AL11 path.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Sep 09, 2017 at 03:36 PM

    Hi Ramprasad!

    You could use adapter module for your requirement:

    https://blogs.sap.com/2014/10/21/exceltransformbean-part-1-convert-various-excel-formats-to-simple-xml-easily/

    Another way is to use java mapping to read Excel attachment using any external java class for managing Excel files and transform the data to output XML structure.

    Regards, Evgeniy.

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 06, 2017 at 08:54 AM

    Hi Ramprasad!

    So you can use the module mentioned above next to PayloadZipBean in order to convert your unzipped Excel file into XML.

    Regards, Evgeniy.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 06, 2017 at 08:44 AM

    Hello Evgeniy,

    Thanks for your reply on the issue.

    But we worked with PayloadSwapBean Module to swap the mail content with excel file attachment which is a .zip file actually and then used PayloadZipBean Module to unzip our file.

    Add comment
    10|10000 characters needed characters exceeded