Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

How to export long formatted text from SAP to an excel Cell

Former Member
0 Kudos
2,303

I have created an object(ZMM_TXT_PD) and an ID(Y01) using se75 transaction.

With a Z program a store some lines in STXH table with object ZMM_TXT_PD and ID Y01.

These texts are very long and formmated.

Now I need another Z program in order to download all the stored texts in an excel file.

I have a program which is able to download an internal table to an excel. The problem is that

it only works with short texts. How could I download a long text that I get using READ_TEXT function

into an excel cell?

READ_TEXT returns an internal table like this:

i_tline TYPE STANDARD TABLE OF tline.

Thanks in advance.

4 REPLIES 4

Former Member
0 Kudos
409

Hi,

Use the following link for exporting formatted data into excel

http://saptechsolutions.blogspot.com/2012/01/send-email-of-xml-format-data-as-excel.html

0 Kudos
409

Code is not working. I have created a report with the code an executed it. Excel is created but an error raises when trying to open it. Error says that a .log file is created but there is not such a file.

0 Kudos
409

You can use CALL FUNCTION 'READ_TEXT' and CALL FUNCTION 'CONVERT_TABLE_TO_STRING' to get the long text into a single cell in an excel.

Thanks,

K.Kiran.