Download the output into Excel...(List->export->spreadsheet)

[Former Member]

Dear friends,

I want to download the output into Excel...

I am using all SAP standards and using the ALV Block list

Ex: List->export->local file.. is anable from here i can download to excell .....but the same there is anothere option : List->export->spreadsheet...( this one inactive.)

I want to activate the List->export->spreadsheet option.

how to do this???

Thanks,

Sridhar.

[Former Member]

Hi

You can use the fun module

EXCEL_OLE_STANDARD_DAT for general report to download to excel.

For ALV if it is not working,

I feel something wrong with the PF status of the report.

See a standard report in which that download Button is working correctly and copy that status to this report and use.

reward points if useful

regards,

Anji

[sreeramkumar_madisetty]

Hi

Use the Function Module:

EXCEL_OLE_STANDARD_DAT

For your purpose.

But by default you can get the option to download into several formats including your desired one.

Regards,

Sreeram