Excel sheet format using cl_bcs_convert to send email

[former_member216611]

Hi All,

I am sending email with order details in Excel format. Currently first line ( subject ) is also going with the same format of data.

is there any method or attribute to convert first row of Excel data to Bold or Highlight in different colour.

I am converting string to excel by using below method.

cl_bcs_convert=>string_to_solix(

               EXPORTING

               iv_string = l_line " l_lne is a string and it contain all the data

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

               iv_add_bom = 'X' "for other doc types

               IMPORTING

               et_solix = gt_binary_content

               ev_size = gv_size ).

Please suggest. Thanks in advance.

Regards,

Siva Krishna

[former_member216611]

Hi All,

I am sending email with order details in Excel format. Currently first line ( subject ) is also going with the same format of data.

is there any method or attribute to convert first row of Excel data to Bold or Highlight in different colour.

I am converting string to excel by using below method.

cl_bcs_convert=>string_to_solix(

               EXPORTING

               iv_string = l_line " l_lne is a string and it contain all the data

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

               iv_add_bom = 'X' "for other doc types

               IMPORTING

               et_solix = gt_binary_content

               ev_size = gv_size ).

Please suggest. Thanks in advance.

Regards,

Siva Krishna

[rosenberg_eitan]

Hi,

Based on "string_to_solix" I assuming that you actually sending a text CSV file .

Instead of using CSV you can compose and send HTML table .

For some code Have a look here .

Regards.

Eitan.

[prajeshdesai]

Try with OLE2 objects,

data:  h_cell        type ole2_object.

call method of excel 'Cells' = h_cell
   exporting
   #1 = 1
   #2 = 2.

set property of h_cell 'Bold' = 1.

Referece thread:

Hope this helps.