excel

[Former Member]

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

[Former Member]

Hi

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.

[Former Member]

Hi,

After executing the Report, from the Menu bar

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

Try this,

KC

[Former Member]

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