topic Re: Excel generated based on layout and send into mail in Application Development and Automation Discussions

Excel generated based on layout and send into mail

former_member261787 — Tue, 14 Feb 2017 04:33:51 GMT

I need to send excel in mail based on selected layout.

Any function module to convert spool in excel and send into mail.

Re: Excel generated based on layout and send into mail

RaymondGiuseppi — Tue, 14 Feb 2017 06:32:54 GMT

From a spool (abap list or even OTF) I don't think you will be successful, but from an ALV you may be luckier:

Using

cl_salv_bs_runtime_info=>set " prevent ALV display and store data/metadata
submit report " execute ALV
cl_salv_bs_runtime_info=>get_data_ref " get data
cl_salv_bs_runtime_info=>get_metadata " get metadata
cl_salv_ex_util=>factory_result_data_table " prepare data
cl_salv_bs_tt_util=>if_salv_bs_tt_util~transform " generate xml
cl_salv_bs_runtime_info=>clear_all " cleanup

you should get a xml similar to the result of menu List, Export, Spreadsheet.

Regards,
Raymond

Re: Excel generated based on layout and send into mail

matt — Tue, 14 Feb 2017 06:57:47 GMT

I wrote a program to do this. There are function module to read the spool. You can then, after writing code (similar to a screen scraper) to get the information in some kind of order, using some standard code (search for it - it's not hard to find) or abap2xlsx to output an Excel spreadsheet.

Sending it by mail is very simple and well documented - you should search to see how it is done. There are some useful blogs.

There is no single function module that does what you want. You have to write ABAP code yourself.