topic How to convert internal table data into excel format? in Application Development and Automation Discussions

How to convert internal table data into excel format?

arpita_churi3 — Thu, 04 Dec 2008 04:42:13 GMT

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.

Re: How to convert internal table data into excel format?

Former Member — Thu, 04 Dec 2008 04:45:14 GMT

HI,

You can give the format as .DAT

Then, it will open with AS-EXCEL also.

Hope this helps.

Regards,

Rajat

Re: How to convert internal table data into excel format?

Former Member — Thu, 04 Dec 2008 04:47:10 GMT

Use SO_NEW_DOCUMENT_SEND_API1 FM

Refer This LInk

Ranga

Re: How to convert internal table data into excel format?

Former Member — Thu, 04 Dec 2008 04:50:40 GMT

please refer to this thread

hope this helps

regards

Aakash Banga

Re: How to convert internal table data into excel format?

Former Member — Thu, 04 Dec 2008 04:52:16 GMT

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

Re: How to convert internal table data into excel format?

former_member632729 — Thu, 04 Dec 2008 04:56:56 GMT

Hi,

use this FM SAP_CONVERT_TO_XLS_FORMAT

Raghunath.S

Re: How to convert internal table data into excel format?

arpita_churi3 — Thu, 04 Dec 2008 12:12:18 GMT

Hi,

Thanks for reply.

it is working now.

Regards,

Arpita