Reg-EXCEL File

[Former Member]

Hi experts,

I retrieved the ALV output into an internal Table which is containing Text(1024) as member.

After getting Data I need to pass this data to Excel file.

Excel file should contain exact format of ALV and after creating that excel file that file as go to enduser and as an attachment, No need of Involvement of Presentation Server here.

Please suggest me..............

Regards,

Subash

[Former Member]

Hi experts,

I retrieved the ALV output into an internal Table which is containing Text(1024) as member.

After getting Data I need to pass this data to Excel file.

Excel file should contain exact format of ALV and after creating that excel file that file as go to enduser and as an attachment, No need of Involvement of Presentation Server here.

Please suggest me..............

Regards,

Subash

[Former Member]

Hello,

U can do like this.

DATA: SV_ADR TYPE AD_SMTPADR.

SELECT-OPTIONS: SO_ADR FOR SV_ADR NO INTERVALS.

LOOP AT SO_ADR.

L_F_EMAILID = SO_ADR-LOW.

PERFORM SEND_EMAIL_ATTACHMENT USING GT_ATTACHMENT[]

L_F_EMAILID

L_F_TITLE.

ENDLOOP.

CALL FUNCTION 'SO_NEW_DOCUMENT_ATT_SEND_API1'

EXPORTING

document_data = lwa_document_data

TABLES

packing_list = lit_packing_list

contents_bin = lit_contents_bin

contents_txt = lit_contents_txt

receivers = lit_receivers

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.

Cheers,

Vasanth

[Former Member]

Check this thread

Regards,

Maha