Excel formating in email attachment without using XML.
I have a requirement where in I am sending an excel as an attachment, now the requirement is to format this excel.
Scenario: An email is to be sent with attached excel, the column headings should be in BOLD, the columns should be emphasized/optimized,
few of the columns are to be colored and so on...
Please do suggest an approach to ahcieve this, I am using below code...
iv_string = lv_string
iv_codepage = '4103' "suitable for MS Excel, leave empty
iv_add_bom = 'X' "for other doc types
et_solix = binary_content
ev_size = size ).
* add the spread sheet as attachment to document object
i_attachment_type = 'xls' "#EC NOTEXT
i_attachment_subject = 'Process' "#EC NOTEXT
i_attachment_size = size
i_att_content_hex = binary_content ).
I have tried to achieve it using FM: SO_NEW_DOCUMENT_ATT_SEND_API1
Note: Please don't provide links which are saying XML to excel conversion, there is an issue with this.