Skip to Content
0
Former Member
Mar 02, 2009 at 12:42 PM

size of excel column

118 Views

hi all ,

i am using following code to send excel as an email attachment.

In last column, some values are not dispalyed ( while some are partially displayed).

Is this a size problem.

how should i increase the size of row ?

i am using FM 'SO_NEW_DOCUMENT_ATT_SEND_API1'.

Is there any other FM that allows a larger size ?

thanks in advance

**File Type

ld_format = 'XLS'.

**File Name

ld_attfilename = 'File1'.

  • Fill the document data.

gd_doc_data-doc_size = 1.

  • Populate the subject/generic message attributes

gd_doc_data-obj_langu = sy-langu.

gd_doc_data-obj_name = 'SAPRPT'.

gd_doc_data-obj_descr = psubject .

gd_doc_data-sensitivty = 'F'.

  • Fill the document data and get size of attachment

CLEAR gd_doc_data.

  • Populate the subject/generic message attributes

gd_doc_data-obj_langu = sy-langu.

  • READ TABLE it_attachment INDEX w_cnt.

DESCRIBE TABLE it_attachment LINES w_cnt.

gd_doc_data-doc_size = ( w_cnt - 1 ) * 255 + STRLEN( it_attachment ).

  • gd_doc_data-doc_size = w_cnt * 255.

gd_doc_data-obj_name = 'SAPRPT'.

gd_doc_data-obj_descr = psubject.

gd_doc_data-sensitivty = 'F'.

  • Describe the body of the message

CLEAR it_packing_list.

REFRESH it_packing_list.

it_packing_list-transf_bin = space.

it_packing_list-head_start = 1.

it_packing_list-head_num = 0.

it_packing_list-body_start = 1.

DESCRIBE TABLE it_message LINES it_packing_list-body_num.

it_packing_list-doc_type = 'RAW'.

APPEND it_packing_list.

**Describe the attachment info

it_packing_list-transf_bin = 'X'.

it_packing_list-head_start = 1.

it_packing_list-head_num = 1.

it_packing_list-body_start = 1.

DESCRIBE TABLE it_attachment LINES it_packing_list-body_num.

it_packing_list-doc_type = ld_format.

it_packing_list-obj_name = ld_attfilename.

it_packing_list-obj_descr = ld_attfilename.

it_packing_list-doc_size = it_packing_list-body_num * 255.

APPEND it_packing_list.