Skip to Content
author's profile photo
Former Member

download to excel

hi,

we r upgrading from 3.1i to 4.7.

using the function module EXCEL_OLE_STANDARD_DAT TO DONLOAD to excel.

this function module works fine in 3.1i. when executed in 4.7 its giving short dump if internal table is of packed or currency or quantity.

if internal table converted to character its working.i dont want to convert and download as it may be used in some other application.

pls give me the function module which downloads to excel which takes all data type.

Regards

Ajay

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • Dec 08, 2003 at 09:01 AM

    I usually use the class CL_GUI_FRONTEND_SERVICES and the method GUI_DOWNLOAD. Just choose filetype ASC and pass a X to the value write_field_separator. This will write out a tab-delimited text file that Excel should have no problem reading. This is very similar to using the old WS_DOWNLOAD or DOWNLOAD function module.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Thomas!

      You could with the FM WS_DOWNLOAD and with filetype “DAT” export the column heading. The FM can download only table body in “ASC”.

      Question: how can you download column heading as additional to the internal table body with the class CL_GUI_FRONTEND_SERVICES?

  • author's profile photo
    Former Member
    May 03, 2004 at 08:27 AM

    Hi Thomas,

    I have had the same problem a couple of days ago. After analysing the class-methods i realized, that it won't work.

    In fact there is a property for exporting header-lines, but it won't be used by the excel exchange; only for the text-export!

    It is funny, becouse some methods are reading the complete DDIC Infos; except the header-textes:((

    I am sorry to tell you that.

    BR

    Michael

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    May 03, 2004 at 08:30 AM

    Hello ajay,

    For this case i use EXCEL inplace. That is the only way to handle MS-EXCEL in special cases.

    Let me know, if you need some sample coding.

    BR

    Michael

    Add comment
    10|10000 characters needed characters exceeded