ALV

[Former Member]

Hi,

I have a ALV report. I'm trying to use the Excel export std option in ALV to export ALV report to EXCEL spreadsheet.But when i click on the EXCEL icon ,i see no datas in the excel sheet.

Pls help what could be the problem

Ram

[Former Member]

Hello Prabha,

Are U using the Objects for displaying the ALV.If So,

U have to do like this.

DATa: G_R_EXCL TYPE UI_FUNCTIONS,

APPEND CL_GUI_ALV_GRID=>MC_FC_GRAPH TO G_R_EXCL.

APPEND CL_GUI_ALV_GRID=>MC_FC_INFO TO G_R_EXCL.

APPEND CL_GUI_ALV_GRID=>MC_FC_PRINT_BACK TO G_R_EXCL.

CALL METHOD G_R_GRID->SET_TABLE_FOR_FIRST_DISPLAY

EXPORTING

I_BUFFER_ACTIVE = G_C_SET

IS_VARIANT = G_R_VARIANT

IS_LAYOUT = G_R_LAYO

IT_TOOLBAR_EXCLUDING = G_R_EXCL

I_SAVE = G_C_SET

I_DEFAULT = G_C_SET

CHANGING

IT_OUTTAB = G_T_HEADER

IT_FIELDCATALOG = G_T_FIELDCAT_C.

Don't forget to award points.

Regards,

Vasanth

[Former Member]

Hi Vasanth,

Thanks fo rth ereply.

Where to use/call this method?

Pls help in detail

Ram

[Former Member]

Hi Prabha,

Don't use that button, use only this...

try this way..

from Local file option(CtrlSHFTF9) ->Spread Sheet (Radiobutton) and Ok give the file path and enter.

Now see.

Regards

vijay

[Former Member]

Hi,

Open your Excel and go to menu: Tools -> Macros -> and mark in the second label both checkboxes.

Hope it helps.

Mireia