topic Re: Read excel file from Application layer i.e Al11 into internal table in Application Development and Automation Discussions

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

Dhanasekhar — Mon, 04 Mar 2019 09:28:54 GMT

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

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

matt — Mon, 04 Mar 2019 12:00:23 GMT

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

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

Dhanasekhar — Mon, 04 Mar 2019 14:07:38 GMT

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-internal-table_1.pdf

if you have something more details kindly share.

Thanks- sekhar

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

SimoneMilesi — Tue, 05 Mar 2019 08:55:00 GMT

Did you find ABAP2XLSX ?

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

former_member1716 — Tue, 05 Mar 2019 09:24:27 GMT

You Can use this FM below for the same:

TEXT_CONVERT_XLS_TO_SAP

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

matt — Tue, 05 Mar 2019 10:05:46 GMT

What Simone said. ABAP2XLSX is what you need.

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

Dhanasekhar — Tue, 05 Mar 2019 10:56:46 GMT

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

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

SimoneMilesi — Tue, 05 Mar 2019 11:31:09 GMT

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

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

matt — Tue, 05 Mar 2019 12:31:43 GMT

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

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

DoanManhQuynh — Wed, 06 Mar 2019 03:02:21 GMT

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.

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

nanda_veera — Fri, 12 Jul 2019 20:38:46 GMT

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.

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

matt — Sat, 13 Jul 2019 07:47:11 GMT

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

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

Sandra_Rossi — Sun, 14 Jul 2019 01:49:19 GMT

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.