Skip to Content
author's profile photo Former Member
Former Member

Read only mode for Excel sheet

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on May 24, 2011 at 06: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.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on May 20, 2011 at 04: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.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 20, 2011 at 06: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.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 21, 2011 at 05:17 AM

    Hi,

    reuse_alv_grid_display function module

    This link may lead to solve your problem.

    Regards,

    Anusha.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      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

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.