fixed column length in excel using cl_bcs_convert=>string_to_solix

[ravikiran558]

Hello All,

I am using cl_bcs_convert=>string_to_solix to send a internal table as excel attachment in a mail in SAP.

Able to achieve the excel - but the data is not aligned correctly, i mean i want fixed length for all the fields in excel. Also i want to colour heading of the excel fields.

CONCATENATE gv_string <dyn_wa> gc_tab gc_crlf INTO gv_string.

    TRY.
        CALL METHOD cl_bcs_convert=>string_to_solix
          EXPORTING
            iv_string   = gv_string
            iv_codepage = '4103'   "UTF-16LE preferred by Microsoft Excel
            iv_add_bom  = abap_true  "Byte order mark
          IMPORTING
            et_solix    = lt_string
            ev_size     = lv_size.
      CATCH cx_bcs.
        MESSAGE e445(so).
    ENDTRY.

Thanks in advance

[Sandra_Rossi]

I don't understand what "fixed column length" means, could you share a picture of what you get and what you expect? Of course, the method string_to_solix is not related to colors in Excel. For Excel formatting, use abap2xlsx for instance.

[Tomas_Buryanek]

Yes as Sandra says. You are not creating proper Excel file, but simple "tab delimited text file". If you want anything better then simple text file - if you want formating etc. then check other methods how to create Excel file in ABAP. One of the best ways is ABAP2XLSX open source library.