Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
Showing results for 
Search instead for 
Did you mean: 

Reading excel (xls or xlsx) attachment from inbound mail

Active Participant

Requirement is to read attachment of inbound mails to SAP. I am able to read csv or txt attachment but not able to convert xls or xlsx binary data into internal table format.

I have tried a lot of options and class CL_XLSX_DOCUMENT seems to work partially. It is able to read partial data into xml format but not completely. It is reading all headers but for actual data, it is not reading in sequence and not all rows and generating one row with mixing up data from 2 rows.

Has anyone encountered this issue? Is there any alternative method for this?


0 Kudos

ALSM_EXCEL_TO_INTERNAL_TABLE function module can be used for XLSX extension furthernore CALL FUNCTION 'TEXT_CONVERT_XLS_TO_SAP' can be used in case of XLS extension.