Need Inputs on how to download data into excel from an internal table

[ABAPer_1631]

Hello,

Need inputs on below requirement:

I would like to move data into excel of an internal table which has a field that stores long text with multiple lines separated by '#' (cl_abap_char_utilities=>newline). I would like to replace "#' with some character so that it will add that entry in a new line in the downloaded excel.

Please find the below use case:

say, I have data in internal table it_tab1 with work area ls_tab1.

Now, this lstab1-<field> = string1 #string2 #string3

Now, I want input of the field in the downloaded excel as below:

string1

string2

string3

Please provide possible solutions.

Note: I have used below statement still not able to get data as expected.

REPLACE ALL OCCURRENCES OF '#' IN lstab1-<field> WITH cl_abap_char_utilities=>newline.

and I am using SCMS_STRING_TO_XSTRING FM to convert string to xstring.

Thanks in Advance!

[raymond_giuseppi]

During your search before posting, did you find abap2xlsx 

[ABAPer_1631]

Hello,
Before I post this question, I tried many ways of browsing the same. I could not find any. And the link that has been shared in response to the post I could not get exactly what you are trying to tell.

could you please elaborate or explain the solution in detail.

Thanks!

[raymond_giuseppi]

The link access to the project GitHub, to install, but you should already found many related answers with this tool