Hi Experts,
One of our customer requirement was to send the Spool create from Program SAPF100 as an Excel attachment.
In SCOT we have Spool email attachment configuration as PDF hence I have created a program in which I submit the program and use "LIST_FROM_MEMORY" and "LIST_TO_ASCI" to get the data and process.
To make it excel compatible , I have looped on data use cl_bcs_convert=>gc_tab as Horizonal deliimter and cl_bcs_convert=>gc_crlf as vertical delimiter.
Then I have used the Method cl_bcs_convert=>string_to_solix with below parameter
cl_bcs_convert=>string_to_solix
(
EXPORTING
iv_string = g_strmsg
iv_codepage = '4103'
iv_add_bom = 'X'
doc types
IMPORTING
et_solix = l_binary_content
ev_size = l_size ).
Then I call CL_BCS to send email with excel as attachement.
Everything works great only issue is the amount field does not sum up.
Our customer uses "," as decimal notation and "." as thousand separator.
If in user profile I make Decimal notation as "." and thousand separator as "," then it work fine however when I make it vice versa amount field in excel does not sum up.
P.S: I have tried to change column into number format but that does not help.
