cancel
Showing results for 
Search instead for 
Did you mean: 

Excel XLS/XLSX to Internal TABLE

Phani_Kumar
Participant
0 Kudos

Hello,

I have created a tile for a Back end Transaction . Transaction has File Upload Parameter. But When We are using the same transaction through Fiori App , It is leading to Dump . I used GUI_UPLOAD to make it work for CSV Type . But I would like to understand how to make it work from Fiori App even for XLS/XLSX File Types.

Please note that If I am using TEXT_COVERT_XLS_TO_SAP & ALSM_EXCEL_TO_INTERNAL_TABLE & KD*OLE* Function Modules , I am getting OLE Exception . Hence I am getting dumps. So I would like to understand how we can achieve this using GUI_UPLOAD FM or is there any other FM /Class Method that can serve my purpose?

Accepted Solutions (1)

Accepted Solutions (1)

gregorw
Active Contributor
0 Kudos

https://github.com/ivanfemia/abap2xlsx should be your solution.

Answers (2)

Answers (2)

Phani_Kumar
Participant
0 Kudos

Hi gregorw , I have read below comment from another post . It says, we need to install something to get the abap2xlsx. So do we need to install something or do we need to manually write all those classes/programs inside our systems(tedious task ,its like a library having lot of classes/programs)? Please bare with me as these questions may sound stupid for experts like you , But will really help guys like me...Thanks again...

Sandra Rossi

Search for the free tool "abap2xlsx". Demo programs are also provided.

Edit: its advantage compared to OLE or DOI programs (like SAP ECC only function modules ALSM_EXCEL_TO_INTERNAL_TABLE, KCD_EXCEL_OLE_TO_INT_CONVERT, TEXT_CONVERT_XLS_TO_SAP, etc.) is that abap2xlsx can run in background, is much faster, and is available in all ABAP-based systems (by installing it). abap2xlsx operates directly on the XLSX format.

gregorw
Active Contributor
0 Kudos

Please follow the installation instructions to get it installed. You might need to get approval first for abapGit and abap2xlsx as they are Open Source projects and the license might not be allowed at the company you want to use it.

Phani_Kumar
Participant
0 Kudos

Hello gregorw ,

Thank you very much for the reply . I have seen that github blog from ivanfemia. But I am looking for something XLSX2ABAP which means, I wanted to read an excel file data . However ,I found only how to create an excel from that blog . Did I miss anything in that ?is it possible for you to tell me precisely how to achieve this. Desparately need your help..

I have used GUI_UPLOAD gave the output of GUI_UPLOAD to SCMS_BINARY_TO_TEXT ...then I am getting data like below. But from below, I am not able to predict when data part is there and when not ... SO please help

Appreciate your help.

gregorw
Active Contributor

Dear Kayan,

abap2xlsx does also xlsx2abap check the demo report ZDEMO_EXCEL15.