Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

excel

Former Member
0 Kudos
84

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

1 ACCEPTED SOLUTION

Former Member
0 Kudos
44

Hi,

After executing the Report, from the Menu bar

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

Try this,

KC

3 REPLIES 3

Former Member
0 Kudos
44

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
0 Kudos
45

Hi,

After executing the Report, from the Menu bar

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

Try this,

KC

Former Member
0 Kudos
44

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