topic Re: excel in Application Development and Automation Discussions

excel

Former Member — Tue, 06 Nov 2007 11:28:23 GMT

what is the procedure to copy an outputted list into an excel sheet.

Re: excel

Former Member — Tue, 06 Nov 2007 11:33:17 GMT

there are many threads available in this forum for ur question just have a look,

You can use the FM - ALV_XXL_CALL.

It is the same function module invoked when you click on the export to excel button of the ALV.

You can pass teh field catalog of the ALV here along with the name of ur internal table and the internal table itself. It will download everything to Excel alongwith the Column headers ( depending on ur field catalog definition). Just make sure ur field catalog has the COL_Heading correctly populated.

Sample Code - CALL FUNCTION 'ALV_XXL_CALL'

EXPORTING

i_tabname = 'T_GRID' " Name of the Internal table

it_fieldcat = t_fcatk[] " Field catalog

TABLES

it_outtab = t_grid " Interbnal table with data

EXCEPTIONS

fatal_error = 1

no_display_possible = 2

OTHERS = 3.

IF sy-subrc <> 0.

MESSAGE e806(bk).

ENDIF.

Re: excel

Former Member — Tue, 06 Nov 2007 11:48:29 GMT

Hi,

After executing the Report, from the Menu bar

->List->Send->File->Spreedsheet

Try this,

Re: excel

Former Member — Wed, 05 Dec 2007 08:45:31 GMT

Hi Sandeep,

You can save the file in excel format as .

on the list output

List->Save/Send->File->Unconverted

in this change the file extension as " .xls " and then save the file.

It will get stored as an excel file.

Regds,

Gaurav