topic Re: Email excel attachment using BCS classes in Application Development and Automation Discussions

Email excel attachment using BCS classes

Former Member — Thu, 02 Sep 2010 14:17:32 GMT

Hi Folks,

I am using BCS classes to send excel attachment in an mail. Everything is working fine except the Auto fit functionality of the columns. When the user opens the excel attachment he wants to see the columns width to be autofit.

Re: Email excel attachment using BCS classes

_IvanFemia_ — Thu, 02 Sep 2010 22:16:49 GMT

Hi,

check this SDN Blog [abap2xlsx - Generate your professional Excel spreadsheet from ABAP|http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/20046] [original link is broken] [original link is broken] [original link is broken]; could be useful to you.

Regards,

Ivan

Re: Email excel attachment using BCS classes

Former Member — Fri, 03 Sep 2010 04:22:17 GMT

Hi Ivan,

My requirement here is, I have data in internal table and this internal table data has to be sent as an email in excel format. I made use of the standard BCS classes SAP provided and was able to successfully send the excel attachment but the columns here are not auto-fit according to the field width. I used the following classes to send data:

The below class what it does is, it converts the data in string(LV_STRING) into binary_content.

TRY.

cl_bcs_convert=>string_to_solix(

EXPORTING

iv_string = lv_string

iv_codepage = '4103' "suitable for MS Excel, leave empty for other doc types

iv_add_bom = 'X'

IMPORTING

et_solix = binary_content

ev_size = size ).

CATCH cx_bcs.

ENDTRY.

The above binary content is transformed into excel

Add the spread sheet as attachment to document object

document->add_attachment(

i_attachment_type = 'xls'

i_attachment_subject = 'Excel_Attachment_Name'

i_attachment_size = size

i_att_content_hex = binary_content).

Add document object to send request

send_request->set_document( document ).

The links provided by you are very interesting but does not fulfill my requirement. Thanks and appreciate more responses.