[abap2xlsx] Using Excel as input

[leon_thi]

Hello community,

I want to use a report to let the user input values into multiple internal tables through excel. I've already got the output right - there are multiple worksheets each showing a different excel-table where the user can input the data and some additional informations - and now I am struggling to retrieve these changes made in excel back into abap structures to further process the inputs.

What would be a way to make this work using abap2xlsx?

[Sandra_Rossi]

There's no problem to do that, what is your exact issue?

[Former Member]

Hey. You might want to check program SAPRDEMO_TABLES_IN_EXCEL for examples

[leon_thi]

I can't figure out how to continue the program at that moment when the user exits Excel to read the inputs in the worksheets made by the user.

I think I'll just settle with 2 reports instead of one now. Makes it way easier I guess and also doesn't force the user to input all the data straight away. One for download of the excel and one for upload. I know there are already solutions for this available.

[gregorw]

Also with abap2xlsx you will always have to download the generated file, let the user update the information in Excel and then upload the changed file. There is even an example in the abap2xlsx examples.