Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Reading excel (xls or xlsx) attachment from inbound mail

former_member215917
Active Participant

‎2018 May 18 12:11 AM

798

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?

1 REPLY 1

menpa
Advisor
Advisor

‎2018 Jun 06 8:19 PM

0 Kudos
241

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.