show more than 17000 line in excel with use fm GUI_DOWNLOAD

[Former Member]

hi expert.

i want to use GUI_DOWNLOAD for save my internal table to my system.

my internal table has 18 column and more than 17000 line. when i use this fm some of my lines missed.

how can i solve my problem?

thanks for your advise.

[Former Member]

Hi ,

Check this Note : 1120298 - Showcase GUI_DOWNLOAD: Mass data download One sample code given by SAP , It may be resolve your issue .

Regard's

Smruti

[former_member209120]

Hi  maryam ashjaezadeh

Try with cl_gui_frontend_services=>gui_download

DATA: gdf_filepath type dxfile-filename

DATA: gdt_data type table of gts_data.

START-OF-SELECTION.

gdf_filepath = 'C:\mydata.xls'.

CALL METHOD cl_gui_frontend_services=>gui_download

    EXPORTING

      filename                      = gdf_filepath

      filetype                        = 'ASC'

      write_field_separator  = 'X'

CHANGING

      data_tab                      = gdt_data