How to read an .xlsx file stored in the application server into an ABAP internal table?

Question

I have an Excel (.xlsx) file stored in a known path in AL11 which consists of, let's say, 20 columns and 51 rows of data (one of those rows is the column description which is already known to me because it is fixed and therefore can be ignored). I have created a program with the purpose of reading that Excel file and transferring the data into an internal table.

In a similar case in which the file was stored on local computer, I had used the function module ALSM_EXCEL_TO_INTERNAL_TABLE which worked fine, but I do not think it is the appropriate way to use now that the file is stored in the application server.

A colleague of mine suggested using OPEN DATASET statement, but in the past I have only used that statement for reading .txt format files and I do not know whether it can be used for .xlsx files as well or not. Do you have any suggestions? Thanks in advance.

check my answer here: stackoverflow.com/questions/48384802/… — József Szikszai
– József Szikszai, Commented Sep 15, 2021 at 8:10
I cannot really implement an external service like abap2xlsx because my zprogram is designed to run in a customer's system, therefore I do not have the authority to install external services. — Stephon_Gordon
– Stephon_Gordon, Commented Sep 15, 2021 at 9:18
Many customers use abap2xlsx. Developers just need to ask: what about installing abap2xlsx so that to create the Z program in 10 minutes, versus spending days. Anyway, if you're an experienced developer and the Excel file is very simple, it's easy to unzip it and read the data from the worksheet file (data stored in XML format). — Sandra Rossi
– Sandra Rossi, Commented Sep 15, 2021 at 19:44
abap2xlsx is not external service, it is program for import/export excel files. — mkysoft
– mkysoft, Commented Sep 16, 2021 at 12:26

Sandra Rossi · Accepted Answer · 2021-09-20 18:11:29Z

1

You can use abap2xlsx package for Excel import/export operations. It has a lot of feature.

If you are looking minimal reader you can check my xlsxreader

You can see a lot of useful package/tools at ABAP Open Source Projects.

edited Sep 20, 2021 at 18:11

Sandra Rossi

14k6 gold badges28 silver badges58 bronze badges

answered Sep 16, 2021 at 12:29

mkysoft

5,7881 gold badge26 silver badges33 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to read an .xlsx file stored in the application server into an ABAP internal table?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related