ALV functinality - Excel sheet

[Former Member]

hi,

when i use ALV to display the output, we get in the top i.e kind of menu bar where we can see moving into excel sheet , word etc..

i am not able to move into Excel. i am getting all blank.

please let me know.

[Former Member]

Hi,

there are many options with which u can take the data into excel like:

You can use these function modules also:

SAP_CONVERT_TO_XLS_FORMAT

-> MS_EXCEL_OLE_STANDARD_DAT

-> RSPO_DOWNLOAD_SPOOLJOB

RH_START_EXCEL_WITH_DATA

Or on top of the ALV header there are many ways...just try out..

Reward points if useful.

tHanks

nishant

[Former Member]

i don want to use function modules but i tried to use the options on the header they are not working.

[Former Member]

Hi,

In the XL sheet of your system do the following changes to download the data from SAP to XLS directly.

1. Tools -> Macro -> Security

Change the security level to LOW

and in Trusted Publishers check the both the checkboxes.

Thanks,

Srinivas

[Former Member]

i am able to export but there is an option to view also which is not working.

[Former Member]

if i go to print prview and then excel its showing me the data.

i guess some problem.

[Former Member]

then i think this should work..have you tried?

EDIT-> DOWNLOAD->spread sheet--->file name and path

For me it is working

Edited by: Nishant Rana on Jul 23, 2008 1:50 PM

[Former Member]

Hi,

Before executing the program open your excel, do below settings.

Tools>Macro>Security you will get two tabs.

Under security tab choose Low or Medium. And in another tab check both check boxes.

Now execute the Program click on Excel.

[Former Member]

i am just able to download it but not view in excel which is a option in ALV header.

anyways thanks.

[Former Member]

hi in the application tool bar there is an option for that ..

save to local file ->spread sheet->file name and path