SAP Excel Stuff

RSDEMO01

cl_ixml=>create
if_ixml_stream_factory

ALSM_EXCEL_TO_INTERNAL_TABLE
TEXT_CONVERT_XLS_TO_SAP


cl_salv_table->to_xml


data: g_salv type ref to cl_salv_table.

*Build your normal ALV output, I recommend not executing display() method until the end of the program though.

perform build_alv using itab space ps_var.

*Converts your ALV to xstring

x_mhtml = g_salv->to_xml( xml_type = '02'

xml_flavour = if_salv_bs_c_tt=>c_tt_xml_flavour_export ).



*Convert xstring so it can be attached to an email

try.

ct_bin = cl_bcs_convert=>xstring_to_solix( iv_xstring = x_mhtml ).

ch_size = xstrlen( x_mhtml ).

catch cx_bcs.

message e445(so).

endtry.