Skip to Content
0

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

Sep 09, 2017 at 02:51 PM

52

avatar image
Former Member

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Evgeniy Kolmakov Sep 09, 2017 at 03:36 PM
0

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.

Share
10 |10000 characters needed characters left characters exceeded
Evgeniy Kolmakov Oct 06, 2017 at 08:54 AM
0

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.

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Oct 06, 2017 at 08:44 AM
0

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.


capture.png (13.3 kB)
Share
10 |10000 characters needed characters left characters exceeded