topic Problem: ITAB to Excel in Application Development and Automation Discussions

Problem: ITAB to Excel

Former Member — Tue, 29 Dec 2009 14:37:01 GMT

Hello,

I have an internal table whose data has to be sent via mail in an excel format as an attachment.

There is a restriction of 255 characters and I have a large number of columns.

Hence, I tried to look into the forums and understood that i will have to put all the data in a string, then further convert it into xstring, and then finally convert it into binary table.

I did this and i have achieved it as seen from the debugger.

But when i open the excel attachment which i have sent through the FM 'SO_NEW_DOCUMENT_SEND_API1', I get an empty excel sheet with a message that it does not support the format.

I hope we can solve this problem.

Thanks,

Rahul Gupta

Re: Problem: ITAB to Excel

Former Member — Wed, 30 Dec 2009 04:44:35 GMT

Hello,

First Try to download the excel sheet at your desktop by this function module and see whether data is flowing into Excel sheet and then try to use the FM u used.

CALL FUNCTION 'GUI_DOWNLOAD'

EXPORTING

bin_filesize = v_bin_filesize

filename = v_filename

filetype = 'ASC'

write_field_separator = 'X'

TABLES

data_tab = it_det .

CALL FUNCTION 'SO_NEW_DOCUMENT_ATT_SEND_API1'

EXPORTING

document_data = wa_doc_chng

put_in_outbox = 'X'

commit_work = 'X'

TABLES

packing_list = i_objpack

object_header = wa_objhead

contents_bin = i_objbin

contents_txt = i_objtxt

receivers = i_reclist

Regards