topic Re: ALV in Application Development and Automation Discussions

ALV

Former Member — Fri, 07 Jul 2006 07:41:37 GMT

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

Re: ALV

Former Member — Fri, 07 Jul 2006 07:47:03 GMT

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

Re: ALV

Former Member — Fri, 07 Jul 2006 07:48:57 GMT

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

Re: ALV

Former Member — Fri, 07 Jul 2006 07:49:08 GMT

Hi,

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

Hope it helps.

Mireia

Re: ALV

Former Member — Fri, 07 Jul 2006 07:57:44 GMT

Hi Vasanth,

Thanks fo rth ereply.

Where to use/call this method?

Pls help in detail

Ram