Read only mode for Excel sheet
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?
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.