CODEWITHSUNDEEP
excelfileabapapplication-serverinternal-tables
Stephon_Gordon
Stephon_Gordon

Reputation: 45

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

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.

Upvotes: 0

Views: 8369

Answers (1)

mkysoft
mkysoft

Reputation: 5758

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.

Upvotes: 1

Related Questions