topic Re: ALV to Excel in Application Development and Automation Discussions

ALV to Excel

Former Member — Wed, 13 Feb 2008 15:27:25 GMT

Hi experts,

I have a requirement to send ALV report as excel file to external receiver. The excel file should be formatted like the ALV list (with all sums….).

Till now to send excel I was using SO_DOCUMENT_SEND_API1. I assume, that if I will pass to this function proper formatted internal table, I will be able to send a file which will be opened on receiver frontend in format, in which ALV list was designed (?).

Can I download the ALV list to internal table so all the formats, the whole layout, will be kept in excel file?

Thank you

Re: ALV to Excel

former_member194669 — Wed, 13 Feb 2008 15:37:20 GMT

May be create a spool of your ALV and read the spool and send it thru

fm SO_DOCUMENT_SEND_API1.

a®

Re: ALV to Excel

Former Member — Wed, 13 Feb 2008 16:12:50 GMT

Hi,

how to convert then sap-spool to excel file?

thank you

Regards

Juzio

Re: ALV to Excel

former_member194669 — Wed, 13 Feb 2008 16:25:13 GMT

Try this way


"1. Call the following fm to read the spool.
CALL FUNCTION 'RSPO_RETURN_ABAP_SPOOLJOB'
"2. Call the following fm to convert the Spool output into XLS format

CALL FUNCTION 'SAP_CONVERT_TO_XLS_FORMAT'
EXPORTING
I_FIELD_SEPERATOR = '|'
I_LINE_HEADER = '-'
I_FILENAME = 'ZTEST.xls'
TABLES
I_TAB_SAP_DATA = i_spool_output
CHANGING
i_tab_converted_data = i_spool_excel

a®

Re: ALV to Excel

Former Member — Wed, 13 Feb 2008 16:34:59 GMT

good

SAP Recommends the Use of Report RSTXPDFT4 to Convert spool to PDF. You can download your PDF to Presentation Server also using this report.

thanks

mrutyun^

Re: ALV to Excel

Former Member — Wed, 13 Feb 2008 16:38:00 GMT

Hi all,

as in thread

the output table of FM SAP_CONVERT_TO_XLS_FORMAT stays empty after function exectution. What can be wrong?

Thank you.

Regards

Juzio

Re: ALV to Excel

Former Member — Wed, 13 Feb 2008 17:18:19 GMT

Hi,

Please refer to the [link|http://www.sapdev.co.uk/reporting/email/attach_xls.htm]

Thanks,

Sriram Ponna.

Re: ALV to Excel

Former Member — Thu, 14 Feb 2008 08:50:04 GMT

Hi all,

PLEASE read the question. i know how to send an email, the problem is i need to send it formatted like ALV list (with sums) as excel attachement. The idea was to send it first to the sap-spool, get it from there, convert to excel and send. i know how to read spool, but with FM SAP_CONVERT_TO_XLS_FORMAT i am not able to convert the spool to xls. The changing parameter of this FM remains empty after function call. What can be wrong? i call the FM with parameters from the anwser above.

thank you.