How to convert internal table data into excel format?

[arpita_churi3]

Hi all,

I want to convert internal table data in excel format and then

send it as email attachment in workflow.

Please tell me how do i perform this.

Regards,

Arpita.

[arpita_churi3]

Hi,

use this FM SAP_CONVERT_TO_XLS_FORMAT

Raghunath.S

[Former Member]

HI,

You can give the format as .DAT

Then, it will open with AS-EXCEL also.

Hope this helps.

Regards,

Rajat

[Former Member]

Hi

Use SO_NEW_DOCUMENT_SEND_API1 FM

Refer This LInk

Ranga

[Former Member]

hi

please refer to this thread

hope this helps

regards

Aakash Banga

[Former Member]

Hi Arpita,

Try this sample code::

Send mail

maildata-obj_name = 'TEST'.

maildata-obj_descr = 'Test Subject'.

loop at htmllines.

mailtxt = htmllines.

append mailtxt.

endloop.

mailrec-receiver = 'your receiver mail id'.

mailrec-rec_type = 'U'.

append mailrec.

call function 'SO_NEW_DOCUMENT_SEND_API1'

exporting

document_data = maildata

document_type = 'EXL'

put_in_outbox = 'X'

tables

object_header = mailtxt

object_content = mailtxt

receivers = mailrec

exceptions

too_many_receivers = 1

document_not_sent = 2

document_type_not_exist = 3

operation_no_authorization = 4

parameter_error = 5

x_error = 6

enqueue_error = 7

others = 8.

if sy-subrc 0.

MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO

WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.

endif.

Hope it will help you.

Regards,

NIkita

[former_member632729]

Hi,

use this FM SAP_CONVERT_TO_XLS_FORMAT

Raghunath.S

[arpita_churi3]

Hi,

Thanks for reply.

it is working now.

Regards,

Arpita