Skip to Content
0
Nov 26, 2009 at 06:40 AM

Blank line in excel using SO_NEW_DOCUMENT_ATT_SEND_API1

135 Views

Hi Experts

I have a small issue while using the FM "SO_NEW_DOCUMENT_ATT_SEND_API1". I am sending an excel file using this function module, but in the mail, the excel has one blank row on top. My client people doesnt want it.

Is there any method where we can control this in the program. I m filling pack list like below

CLEAR i_pack_list-transf_bin.

i_pack_list-head_start = 1.

i_pack_list-head_num = 1.

i_pack_list-body_start = 1.

i_pack_list-body_num = i_lines.

i_pack_list-doc_type = 'RAW'.

APPEND i_pack_list.

DESCRIBE TABLE i_excel LINES i_lines.

READ TABLE i_excel INDEX i_lines.

i_pack_list-transf_bin = 'X'.

i_pack_list-head_start = '1'.

i_pack_list-head_num = '1'.

i_pack_list-body_start = '1'.

i_pack_list-body_num = i_lines.

i_pack_list-doc_type = 'XLS'.

i_pack_list-obj_name = 'Propose UWYR Results'.

CONCATENATE 'Propose UWYR Results' sy-datum INTO i_pack_list-obj_descr SEPARATED BY space.

i_pack_list-obj_langu = 'E'.

i_pack_list-doc_size = i_lines * 255.

APPEND i_pack_list.

CLEAR i_pack_list.

Please suggest me if there is any other alternative.

Thanks

Praveen