topic Re: Internal Table to Excel in Application Development and Automation Discussions

Internal Table to Excel

Former Member — Mon, 10 Nov 2008 16:07:42 GMT

Hello.

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

Thanks.

Re: Internal Table to Excel

Former Member — Mon, 10 Nov 2008 16:10:05 GMT

Hi,

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

Regards, Dieter

Re: Internal Table to Excel

Former Member — Mon, 10 Nov 2008 16:14:35 GMT

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.

Re: Internal Table to Excel

Former Member — Mon, 10 Nov 2008 16:29:04 GMT

I've used WS_EXCEL and it works fine.

Thanks anyway.

Re: Internal Table to Excel

Former Member — Mon, 10 Nov 2008 16:33:38 GMT

The function module WS_EXCEL is obsolete.

Re: Internal Table to Excel

Former Member — Mon, 10 Nov 2008 18:39:05 GMT

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.

Re: Internal Table to Excel

Former Member — Mon, 10 Nov 2008 19:57:20 GMT

 Use the Function Module -   "ALSM_EXCEL_TO_INTERNAL_TABLE".

Regards

Ganesh Reddy.

Re: Internal Table to Excel

Former Member — Mon, 10 Nov 2008 20:24:30 GMT

The requirements was for Internal Table -> Excel.

Not Excel -> Internal Table.

Re: Internal Table to Excel

shekhar01 — Fri, 15 Mar 2024 09:35:13 GMT

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

Re: Internal Table to Excel

shekhar01 — Fri, 15 Mar 2024 09:36:30 GMT

what is gd_layout?
Does it gives straightforward excel output?