05-19-2011 9:27 AM
Hi Experts,
While exporting ALV Report values to Excel sheet, can we make the excel file Read only?
I created an ALV report.User will export this report into an Excel file.It can be manipulated.I want to restrict any alterations to this file.
Can i do this using ABAP programming?
Regards,
Sibinraj
05-24-2011 7:54 AM
Hi,
No, you can't set the file properties using FILE_SAVE_DIALOG.
For this use the method CL_GUI_FRONTEND_SERVICES=>FILE_SET_ATTRIBUTES.
regards,
anusha.
05-20-2011 5:16 AM
Found this link in SDN Wiki.Hope it may give you some lead
http://wiki.sdn.sap.com/wiki/display/Snippets/DownloadDataintoMultipleSheetExcelDocumentwithNonEditableColumns(Passwordprotected)UsingABAP+OLE
Thanks,
K.Kiran.
05-20-2011 8:49 PM
05-20-2011 7:04 AM
Hi,
Check is_print in the alv function module it will directly print the values into the excel file of any file u specified, then there is no chance to modify the values .
regards.
05-21-2011 5:51 AM
05-21-2011 6:17 AM
05-24-2011 6:21 AM
Hi Anusha,
Thanx for your reply.I checked the links but I was unable to export the file to Excel in Read only mode.I used CL_GUI_FRONTEND_SERVICES=>FILE_SAVE_DIALOG to download the file to desktop.Can we make the file Read only using this function module?
Regards,
Sibinraj
05-24-2011 7:54 AM
Hi,
No, you can't set the file properties using FILE_SAVE_DIALOG.
For this use the method CL_GUI_FRONTEND_SERVICES=>FILE_SET_ATTRIBUTES.
regards,
anusha.
05-24-2011 8:15 AM
You can use the method FILE_SET_ATTRIBUTES of class CL_GUI_FRONTEND_SERVICES. You may refer here on how to use that method. The parameter READONLY can be used for the purpose.
http://help.sap.com/saphelp_tm80/helpdata/en/4f/09e5682e794e1185a29b19646b9873/content.htm
05-26-2011 5:59 AM
Thanx all for your valuable feedback.
Its resolved now.
Regards,
Sibinraj