2008 Jul 23 12:08 PM
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.
2008 Jul 23 12:33 PM
hi in the application tool bar there is an option for that ..
save to local file ->spread sheet->file name and path
2008 Jul 23 12:17 PM
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
2008 Jul 23 12:19 PM
i don want to use function modules but i tried to use the options on the header they are not working.
2008 Jul 23 12:29 PM
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
2008 Jul 23 12:35 PM
i am able to export but there is an option to view also which is not working.
2008 Jul 23 12:38 PM
if i go to print prview and then excel its showing me the data.
i guess some problem.
2008 Jul 23 12:49 PM
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
2008 Jul 23 1:46 PM
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.
2008 Jul 23 2:08 PM
i am just able to download it but not view in excel which is a option in ALV header.
anyways thanks.
Bluesky
