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

[Former Member]

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.

[Former Member]

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

[Former Member]

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.

[Former Member]

HI,

U can try the below link,

http://saptechsolutions.blogspot.com/2012/01/download-long-texts-of-documents-into.html

[kiran_k8]

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.