topic Re: How to put READONLY functionality for EXCEL in OLE2_OBJECT in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/how-to-put-readonly-functionality-for-excel-in-ole2-object/m-p/8459341#M1650189 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Use the following statements for READONLY</P><P></P><P> CALL METHOD OF w_excel1 'Columns' = w_columns.</P><P> SET PROPERTY OF w_columns 'Locked' = 0.</P></BODY></HTML> Tue, 17 Jan 2012 13:09:52 GMT Former Member 2012-01-17T13:09:52Z How to put READONLY functionality for EXCEL in OLE2_OBJECT https://community.sap.com/t5/application-development-and-automation-discussions/how-to-put-readonly-functionality-for-excel-in-ole2-object/m-p/8459339#M1650187 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>i want to put 'READONLY' functionality while i download data into excel.</P><P></P><P>i'm using OLE2_OBJECT to download data and other formating stuff.</P><P></P><P>Please let me know how to put readonly option with example code.</P></BODY></HTML> Tue, 17 Jan 2012 08:41:09 GMT https://community.sap.com/t5/application-development-and-automation-discussions/how-to-put-readonly-functionality-for-excel-in-ole2-object/m-p/8459339#M1650187 Former Member 2012-01-17T08:41:09Z Re: How to put READONLY functionality for EXCEL in OLE2_OBJECT https://community.sap.com/t5/application-development-and-automation-discussions/how-to-put-readonly-functionality-for-excel-in-ole2-object/m-p/8459340#M1650188 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>You can use the method FILE_SET_ATTRIBUTES of class CL_GUI_FRONTEND_SERVICES. The parameter READONLY can be used for the purpose.</P><P></P><P><A href="http://help.sap.com/saphelp_tm80/helpdata/en/4f/09e5682e794e1185a29b19646b9873/content.htm" target="test_blank">http://help.sap.com/saphelp_tm80/helpdata/en/4f/09e5682e794e1185a29b19646b9873/content.htm</A></P></BODY></HTML> Tue, 17 Jan 2012 09:36:55 GMT https://community.sap.com/t5/application-development-and-automation-discussions/how-to-put-readonly-functionality-for-excel-in-ole2-object/m-p/8459340#M1650188 Former Member 2012-01-17T09:36:55Z Re: How to put READONLY functionality for EXCEL in OLE2_OBJECT https://community.sap.com/t5/application-development-and-automation-discussions/how-to-put-readonly-functionality-for-excel-in-ole2-object/m-p/8459341#M1650189 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Use the following statements for READONLY</P><P></P><P> CALL METHOD OF w_excel1 'Columns' = w_columns.</P><P> SET PROPERTY OF w_columns 'Locked' = 0.</P></BODY></HTML> Tue, 17 Jan 2012 13:09:52 GMT https://community.sap.com/t5/application-development-and-automation-discussions/how-to-put-readonly-functionality-for-excel-in-ole2-object/m-p/8459341#M1650189 Former Member 2012-01-17T13:09:52Z Re: How to put READONLY functionality for EXCEL in OLE2_OBJECT https://community.sap.com/t5/application-development-and-automation-discussions/how-to-put-readonly-functionality-for-excel-in-ole2-object/m-p/8459342#M1650190 <HTML><HEAD></HEAD><BODY><P>Hi Ravi,</P><P></P><P>i tried but it is doing anything.</P><P>it still allow to change columns.</P><P></P><P>below is d code:</P><P> CALL METHOD OF e_appl 'Columns' = COLUMN.</P><P> set PROPERTY OF COLUMN 'Locked' = 0.</P><P> CALL METHOD OF COLUMN 'Autofit'.</P><P> free object COLUMN.</P><P></P><P></P><P> call method of e_work 'SAVEAS'</P><P> EXPORTING</P><P> #1 = p_file</P><P> #2 = 1</P></BODY></HTML> Tue, 17 Jan 2012 13:47:28 GMT https://community.sap.com/t5/application-development-and-automation-discussions/how-to-put-readonly-functionality-for-excel-in-ole2-object/m-p/8459342#M1650190 Former Member 2012-01-17T13:47:28Z