topic Re: Generating Excel file in Application Development and Automation Discussions

Generating Excel file

Former Member — Tue, 21 Jun 2005 19:30:32 GMT

Hi,

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

Re: Generating Excel file

RichHeilman — Tue, 21 Jun 2005 20:16:04 GMT

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

Re: Generating Excel file

Former Member — Wed, 22 Jun 2005 06:19:03 GMT

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,

Re: Generating Excel file

Former Member — Wed, 22 Jun 2005 06:38:59 GMT

U can even use 'MS_EXCEL_OLE_STANDARD_DAT'.

With Rgs

Re: Generating Excel file

Former Member — Wed, 22 Jun 2005 06:57:50 GMT

WS_EXCEL is obsolete....

GUI_DOWNLOAD is another option

Re: Generating Excel file

Former Member — Wed, 22 Jun 2005 10:14:05 GMT

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

Re: Generating Excel file

Former Member — Wed, 22 Jun 2005 12:18:06 GMT

Hi Kisu,

Hope this helps:

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

Regards,

Ville Leivo