Read excel file from Application layer i.e Al11 into internal table

[Dhanasekhar]

Need to Read an excel file from Application layer i.e Al11 into an internal table,please if any one has code and can share to me

rd

[matt]

Have you tried searching to see if someone else has had this problem?

[Dhanasekhar]

Hi Matthew - i searched few posting but all the documents are not clear..

https://praveensg8.files.wordpress.com/2015/04/reading-excel-file-from-application-server-into-abap-...

if you have something more details kindly share.

Thanks- sekhar

[SimoneMilesi]

Did you find ABAP2XLSX ?

[matt]

What Simone said. ABAP2XLSX is what you need.

[former_member1716]

You Can use this FM below for the same:

TEXT_CONVERT_XLS_TO_SAP

[Dhanasekhar]

ABAP2XLSX is not Application Layer Al11.. where i read the code and it shows the Xlxs file from the Presentation layer.

I found the solution for this issue - Step1 :Read the file from the Application layer through open data set.

step2.Create ABAP Dictionary Objects

Step 3: Create Simple Transformation to Parse XML Content

Step 4 : Create Frame work Program to Process XML Files Processing XML Attributes.

Step5: Transfer the data into ABAP internal table.

Please let me further if you have any questions in the above solution.

Thanks

Sekhar

[SimoneMilesi]

You should read better, because I use for many different reports and customers ABAP2XLSX to handle XLSX files both on application and presentation servers.

[matt]

@Dhana Sekhar you are wrong. abap2xlsx works in writing xlsx files to the appserver.

[DoanManhQuynh]

you dont have to create abap dictionary object for this. if you do then everytime your excel format change, you also have to change it too. you can use ABAP2XLSX or cl_xlsx_document too.

[nanda_veera]

Hello Dhana Sekhar,

Would you mind prepare a step-by-step document that could help others? I have the similar requirement and tried Praveen's approach mentioned in his PDF document, but is not working.

Best Regards,

Nanda.

[matt]

nanda.veera Use abap2xlsx. As the original poster has been advised many times. His objections are invalid.

[Sandra_Rossi]

It has already been discussed 1000 times in the forum.

To sum up:

• Use DATASET (OPEN, READ, CLOSE) statements to get the file from your application server (AL11), then parse it.
• If your Excel file is in the latest XLSX format, please use abap2xlsx.
• Other formats, search the forum.