OLE from webdynpro

[Former Member]

Hi All,

Just wondering if it is possible to execute an OLE program from your web dynpro. Basically I have created an OLE report based on this [OLE excel report|http://www.sapdev.co.uk/ms/format-excel.htm] and have tried submitting it from my web dynpro application. Unfortunatily it does not seem to work, it runs the code but just doesnt create the file, the report works fine if i run it directly in SAP. Would be gratfull of any comments as to whether this is even possible or if there is an alternative way of creating a formatted Excel spreadsheet.

Regards

Mart

[Former Member · Accepted solution]

Hello Mart,

The reason could be the security features of the browser which do not allow application to access to the local machine of the user running the application. Hence when you try to run it from WD it do not have access to C:\ drive and hence fails.

You can make use of the CL_GUI_FRONTEND_SERVICES class to save file on local machine from WD. Or can also use FILE_DOWNLOAD UI element provided by WD Framework.

Thanks,

Abhishek

[thomas_jung · Accepted solution]

>You can make use of the CL_GUI_FRONTEND_SERVICES class to save file on local machine from WD.

I hope you meant you can NOT use CL_GUI_FRONTEND_SERVICES from Web Dynpro. That would have been correct. CL_GUI_* classes use the SAPGUI Control Framework - which of course is not present when running Web Dynpro applications in the browser. This would just lead to a short dump.

There is no direct OLE in Web Dynpro. If you want to interact with Microsoft Office - Word or Excel - then consider using the OfficeControl UI element.

http://help.sap.com/saphelp_nw70ehp1/helpdata/en/d1/af8841349e1909e10000000a155106/frameset.htm

In NetWeaver 7.01 and higher there is a new UI element called ACFExecute. This allows you to launch a desktop application and pass command line parameters into it. However this is not full OLE control.

http://help.sap.com/saphelp_nw70ehp1/helpdata/en/47/b91539878a2d67e10000000a42189c/frameset.htm

[Former Member · Accepted solution]

Thanks Thomas for correcting me there.

I meant use cl_wd_runtime_services class methods.

Thanks,

Abhishek

Edited by: abhishek sinha on Feb 4, 2010 3:47 PM