Skip to Content
0
Former Member
Feb 27, 2009 at 09:49 AM

Open Excel directly from ITS

68 Views

Hello forum,

i'm working with our custmom ITS Services since 2004. Therefore we had build an exceldownload via mime_download technology. This works fine for the process:

Saving File with extension .csv from open Popup. After return to the popup click OPEN and Excel will be open.

Now i'm searching for a method to execute the excel directly inside Internet Explorer or in a new window using my data from internal table without saving first.

I know there are sevaral fine methods at class CL_GUI_FRONTEND_SERVICES which work inside R/3 very well, but not by using internal WebAS.

So know my questions:

1) Are there any possible methods / functions to execute excel with data from internal table (have still transported and displayed to ITS Template) ?

2) Maybe there exist ActiveX Controls that could read out a html table an transport this to excel. I do not know any. Meanwhile if one exists, do i need special javascripting for executing the ActiveX?

3) It is no problem to save the data into an .csv file without a dialog by using the

METHOD cl_gui_frontend_services=>gui_download . so maybe an call of a BSP would solve the problem.

Is anyone familar with calling an BSP Application from ITS Service Template which only execute Excel and get the file from saved place before.

I have only worked with simple BSPs. It would be helpful to guide me what to do when i'm at the OnInitialsation Event. The comments and Logs on BSP Forum would not help me very well.

I'll thank you so much

Thorsten

Enviroment Information:

Backend: ECC6.0 SAP BASIS 7.0 Patch level 0014

WebAS integrated ITS Netweaver 7.0 Patch level 0014