topic Re: Read only mode for Excel sheet in Application Development and Automation Discussions

Read only mode for Excel sheet

Former Member — Thu, 19 May 2011 08:27:45 GMT

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

Re: Read only mode for Excel sheet

kiran_k8 — Fri, 20 May 2011 04:16:41 GMT

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.

Re: Read only mode for Excel sheet

Former Member — Fri, 20 May 2011 06:04:05 GMT

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.

Re: Read only mode for Excel sheet

Former Member — Fri, 20 May 2011 19:49:28 GMT

Hi Kiran,

I couldn't open your link.

Regards,

Sibinraj

Re: Read only mode for Excel sheet

Former Member — Sat, 21 May 2011 04:51:57 GMT

Hi Anusha,

can you please elaborate on this.

Regards,

Sibinraj

Re: Read only mode for Excel sheet

Former Member — Sat, 21 May 2011 05:17:39 GMT

Hi,

This link may lead to solve your problem.

Regards,

Anusha.

Re: Read only mode for Excel sheet

Former Member — Tue, 24 May 2011 05:21:35 GMT

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

Re: Read only mode for Excel sheet

Former Member — Tue, 24 May 2011 06:54:35 GMT

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.

Re: Read only mode for Excel sheet

Former Member — Tue, 24 May 2011 07:15:19 GMT

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

Re: Read only mode for Excel sheet

Former Member — Thu, 26 May 2011 04:59:11 GMT

Thanx all for your valuable feedback.

Its resolved now.

Regards,

Sibinraj