Internal Table to Excel

[Former Member]

Hello.

I need to save my internal table data to an excel file. Is there any useful function module to do this???

Thanks.

[Former Member]

Hi,

create the output in ALV-Grid, change layout to excel and save the excel-sheet.

Regards, Dieter

[Former Member]

I've used WS_EXCEL and it works fine.

Thanks anyway.

[Former Member]

You shouldn't use WS_EXCEL.

I use: REUSE_ALV_GRID_DISPLAY

It is very easy to build an excel output with this FM.

    CALL FUNCTION 'REUSE_ALV_GRID_DISPLAY'
         EXPORTING
              i_callback_program = MYREPORT
              is_layout          = gd_layout
              it_fieldcat        = gd_fieldcat[]
              i_save             = 'X'
         TABLES
              t_outtab           = ITAB
         EXCEPTIONS
              program_error      = 1
              others             = 2.

Good luck.

SL

[Former Member]

Use the function GUI_DOWNLOAD

CALL FUNCTION 'GUI_DOWNLOAD'
    EXPORTING
      filename            = w_path
      filetype            = 'DAT'
    TABLES
      data_tab            = it_tab_exp
    EXCEPTIONS
      file_open_error     = 01
      file_write_error    = 02
      invalid_filesize    = 03
      invalid_table_width = 04
      invalid_type        = 05
      unknow_error        = 07.

[shekhar01]

what is gd_layout?
Does it gives straightforward excel output?

[shekhar01]

there is manual process, but could you provide a code to do it.

[Former Member]

The function module WS_EXCEL is obsolete.

[Former Member]

 Use the Function Module -   "ALSM_EXCEL_TO_INTERNAL_TABLE".

Regards

Ganesh Reddy.

[Former Member]

The requirements was for Internal Table -> Excel.

Not Excel -> Internal Table.