Skip to Content
avatar image
Former Member

Excel sheet format in CL_DOCUMENT_BCS

Hi all,

I am using this CL_DOCUMENT_BCS to send internal table data in excel through mail, that is
working fine.

My problem is when i open the excel sheet through mail, it is displayed as below.

But i want the excell to dispay with the necessary colum width as below.

Kindly advice me what need to be done.

1.png (22.7 kB)
2.png (23.4 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Jun 11, 2012 at 03:58 PM

    Hi Rohini,

    Please check this link,

    http://scn.sap.com/thread/1988139

    There are lot of suggestions on how to handle formatted excel.

    My favorite :ABAP2XLSX

    Thanks,

    Shambu

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi.

      Maybe someone will need:

      .....

      l_value = <fname>

      CONDENSE l_value NO-GAPS.

      ....

      r_data->set_attribute_ns( name = 'Type'  prefix = 'ss'  value = 'Number'  ).

      ...

  • avatar image
    Former Member
    Jun 11, 2012 at 06:52 PM

    no details no code no help

    Add comment
    10|10000 characters needed characters exceeded