topic Re: Reg-EXCEL File in Application Development and Automation Discussions

Reg-EXCEL File

Former Member — Mon, 14 Jan 2008 15:22:33 GMT

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

Re: Reg-EXCEL File

Former Member — Mon, 14 Jan 2008 15:29:08 GMT

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

Re: Reg-EXCEL File

Former Member — Mon, 14 Jan 2008 17:57:04 GMT

Check this thread

Regards,

Maha