topic Re: [abap2xlsx] Using Excel as input in Application Development and Automation Discussions

[abap2xlsx] Using Excel as input

leon_thi — Wed, 13 Feb 2019 11:53:07 GMT

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?

Re: [abap2xlsx] Using Excel as input

Sandra_Rossi — Wed, 13 Feb 2019 13:21:11 GMT

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

Re: [abap2xlsx] Using Excel as input

Former Member — Wed, 13 Feb 2019 13:26:43 GMT

Hey. You might want to check program SAPRDEMO_TABLES_IN_EXCEL for examples

Re: [abap2xlsx] Using Excel as input

leon_thi — Thu, 14 Feb 2019 07:39:00 GMT

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.

Re: [abap2xlsx] Using Excel as input

gregorw — Sun, 17 Feb 2019 10:50:29 GMT

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.