topic Re: excel download problem in Application Development and Automation Discussions

excel download problem

Former Member — Mon, 01 Jun 2009 04:34:23 GMT

hi,

using gui_download i am downloading internal into a excel sheet. I am giving field names into another internal table and giving in the function module like this

CALL FUNCTION 'GUI_DOWNLOAD'

EXPORTING

filename = Filepath

filetype = 'ASC'

append = 'X'

write_field_separator = '#'

TABLES

data_tab = ALV_OUT[]

fieldnames = git_fields.

but in the column names if i gave fielname as " previous confirmed qty"..it is displaying only part of it like "previous confirmed"...why is this happening

Re: excel download problem

Former Member — Mon, 01 Jun 2009 04:47:30 GMT

There is a limitation for the Fieldname (Column Name) from GUI_DOWNLOAD

Re: excel download problem

Former Member — Mon, 01 Jun 2009 04:53:17 GMT

How to overcome then?

Re: excel download problem

Former Member — Mon, 01 Jun 2009 05:01:05 GMT

Hi,

61 text-062, "Customer Name1

As above use Text symbol.

text-006 TO wa_excel_tab-name1 ,

Revert if any doubts.

Manas

Re: excel download problem

GauthamV — Mon, 01 Jun 2009 05:04:56 GMT

How did you declare your internal table for fieldnames ?

try this.



  DATA : BEGIN OF it_join_fields OCCURS 0,
             field_name(25),
             END OF it_join_fields.

 CALL FUNCTION 'GUI_DOWNLOAD'
    EXPORTING
     filename                        = file_name
      filetype                        = 'ASC'
      append                          = 'X'
      write_field_separator           = 'X'
    TABLES
      data_tab                        = it_join
      fieldnames                      = it_join_fields
            .

Re: excel download problem

Former Member — Mon, 01 Jun 2009 05:07:02 GMT

Did your problem got sorted out..

Manas

Re: excel download problem

Former Member — Mon, 01 Jun 2009 05:07:57 GMT

Re: excel download problem

Former Member — Mon, 01 Jun 2009 05:08:21 GMT

it is exatly the same i did

Re: excel download problem

kesavadas_thekkillath — Mon, 01 Jun 2009 05:26:28 GMT

paste ur declaration of ur itab...increasing ur field size might solve your problem !!!