Generating Excel file

[Former Member]

Hi,

I have internal table with data, How we generate excel file with that data.

[RichHeilman]

Here is a quick and easy way.

report zrich_0001 .

data: imara type table of mara with header line.

start-of-selection.

  select * into table imara up to 100 rows
            from mara.


  call function 'WS_EXCEL'
       exporting
            filename = 'TEST.XLS'
       tables
            data     = imara.

Regards,

Rich Heilman

[Former Member]

Hi,

You can make use of FM 'EXCEL_OLE_STANDARD_DAT' to download the contents of an internal table to Excel. Get back for any clarifications,

Rgds,

[Former Member]

Hi

U can even use 'MS_EXCEL_OLE_STANDARD_DAT'.

With Rgs

[Former Member]

WS_EXCEL is obsolete....

GUI_DOWNLOAD is another option

[Former Member]

Hi Kisu,

You can also use the FM : ' WS_DOWNLOAD ' to download to data from internal table to PC File.

Hope that helps you.

Regards,

Anjali

[Former Member]

Hi Kisu,

Hope this helps:

http://www.sapdevelopment.co.uk/file/file_updownpop.htm

Regards,

Ville Leivo